Previous Topic Next Topic

Excel Condition format based on Specific Date

Closed
Marc - Aug 27, 2010 at 02:25 PM
 Ray - Aug 27, 2010 at 07:14 PM
I'm trying to use conditional format in Excel to turn the cell GREEN if the date entered is AFTER Sep 30, 2009. Default is Red.

I appreciate any guidance!
Related:

1 response

Answer 1 / 1
Ray
Aug 27, 2010 at 07:14 PM
highlight the range required. in this case F2:F99 then: In conditional formatting:
Condition1 =IF($F2<=DATEVALUE("9/30/2009"),TRUE,FALSE) format red
Condition2 =IF($F2>DATEVALUE("9/30/2009"),TRUE,FALSE) format green
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses