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 date format dd.mm.yyyy - Guide
How to disable a cell in excel based on condition vba ✓ - Excel Forum
Based on the values in cells b77 b81 ✓ - Excel Forum
Format factory - Download - Other
Dash become date on excel ✓ - Office Software 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

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Highlight cell if another cell contains any text

Conditional format based on another cell containing text

How do I change a base location on Instagram?

Similar discussions

Subscribe To Our Newsletter!