Conditional Formatting causing hair loss!

**ahilder70** · 08-13-2012, 06:17 AM

Hi.

This is probably a very basic question, but as someone relatively new to the features available in Excel its one that is driving me mad.

I have a column with a combination of blank cells and dates (in a simple UK format, eg. 13/08/2012).

What I am trying to do is use conditional formatting to highlight just the dates in green if the date is after (ie a future date) tomorrow , and in red if the date is tomorrow, today or any date in the past.

I've tried looking on line, but have so far drawn a blank.

Any help would be appreciated, and then perhaps I can stop pulling what little hair I have left out!

Adrian

**Ace_XL** · 08-13-2012, 06:37 AM

Use two rules..

1. Cell value -- less than or equal to -- =TODAY()+1--format 'red'
2. Cell value -- greater than -- =(TODAY()+1)--format 'green'

Save your hair!

**ahilder70** · 08-13-2012, 07:09 AM

Thanks very much for that. It works a treat on the dates.

Is there any way of getting those formulas to ignore the blank cells though? It is seeing a blank cell as being less than the current date.

Thanks

Adrian