In prior versions, I would easily have been able to do the below. But how do
I do it in 2007 Excel? I really cannot figure it out...
Situation:
I have a table; 5 columns, X rows.
Column 4 contains a date (dd-MM-yyyy) or is blank (I have received no date
to enter from client).
If cell in column 4 i blank or date is later than TODAY(), I want all cells
in the table-row to be font-colour black and if date has passed (TODAYdate)
I want font-colour to be red.
How to do - in a simple way - using conditional formatin Excel 2007?

--
Best regards
Ulf