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!

Excel Condition format based on Specific Date
Excel conditional formatting based on date - Guide
Excel date format dd.mm.yyyy - Guide
How do i find a specific video on youtube - Guide
How to find specific words on a page - Guide
Based on the values in cells b77 b88 ✓ - Excel Forum

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

Similar discussions

Date formatting in dd/mm/yyyy

Highlight cell if another cell contains specific text

help me to add particular cells

How to use conditional format based on text?

Excel: If Date =, then enter a value

Similar discussions

Subscribe To Our Newsletter!