Excel conditional formatting help

Soldato
Joined
6 Jan 2006
Posts
3,369
Location
Newcastle upon Tyne
Im pulling together a sheet of deadlines and have conditionally formatted the cells so that when the date exceeds the deadline they will turn red by using the follow condition:

If cell value is less than [todays date] then colour cell red.

Now this works fine but it sadly also colours any cell that is blank in red too.

Ideally I wanted to apply the formatting to the whole colum so I can just add in new entries with upcoming deadlines and not have to worry about the formatting of it.

Can you think of anyway of doing it?

Thanks, Mark
 
Man of Honour
Joined
17 Oct 2002
Posts
50,384
Location
Plymouth
Add an additional condition that if cell is empty ("") or null then it remains unfilled is the way I normally deal with that.
 
Back
Top Bottom