Excel color coding
Closed
Ed
-
Nov 3, 2010 at 11:24 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 4, 2010 at 10:51 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 4, 2010 at 10:51 AM
Related:
- Excel color code
- Sound card color code - Guide
- Battery reset code - Guide
- Rj45 color code - Guide
- Samsung volume increase code - Guide
- Cs 1.6 code - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 4, 2010 at 10:51 AM
Nov 4, 2010 at 10:51 AM
Hi Ed,
Start by selecting all the cells you want to color. In your case the cell containing the name and the cell containing the date (I used cell B1 for the date).
Then goto the top menu's > format > conditional format.
For condition 1 select "formula is" and enter:
=$B$1=TODAY()
Select the color you want (red).
For condition 2 select "formula is" and enter:
=$B$1-30<=TODAY()
Select the color you want (yellow).
Best regards,
Trowa
Start by selecting all the cells you want to color. In your case the cell containing the name and the cell containing the date (I used cell B1 for the date).
Then goto the top menu's > format > conditional format.
For condition 1 select "formula is" and enter:
=$B$1=TODAY()
Select the color you want (red).
For condition 2 select "formula is" and enter:
=$B$1-30<=TODAY()
Select the color you want (yellow).
Best regards,
Trowa