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

 

Many thanks Dolph, worked a treat. I had to add the new conditional as the first one for it to work but I assume thats fine as it works great.