Conditional formatting using dates in Ex2010

sncb

Board Regular
Joined
Mar 17, 2011
Messages
99
Is a formula needed in Excel 2010 to have cells change to red/yellow/green depending on what date it is w.r.t today. I need to have something like in column R which has dates:

7-30 days

Col R
22/02/11 cell highlighted in red
23/02/11 cell highlighted in red
24/02/11 cell highlighted in red
.
.


4-7 days
17/03/2011 cell highlighted in yellow
17/03/2011 cell highlighted in yellow


Thanks all
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,276
Select column R
Select Conditional Formatting

Condition1:
Cell Value is between =Today()-30 and =Today()-8
Format: Red

Condition2:
Cell Value is between =Today()-7 and =Today()-5
Format: Yellow
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,108,954
Messages
5,525,879
Members
409,669
Latest member
JDCupps

This Week's Hot Topics

Top