Excel Condition format based on Specific Date [Closed]

 Ray -
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!

1 reply

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!