Soldato
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
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