Conditional format 2007 - is this easy?

[UlfHJensen]

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 (TODAY>date)
I want font-colour to be red.
How to do - in a simple way - using conditional formatin Excel 2007?

--
Best regards
Ulf

[p45cal]

Select the whole block of 5 columns and X rows. (Your active cell should
be in the top row, so select it from top left to bottom right)
In conditional formatting choose New Rule (or manage rules, whichever)
then choose 'Use a formula to determine which cells to format'.
In the field 'Format values where this formula is true' enter the likes
of the following (column D was my 4th column, my table being A1:E13)
paying attention to the placing of the $ sysmbols):
=AND(TODAY()>$D1,$D1<>"")
Adjust the formatting to be applied and click OK, twice. QED.

--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=156813

[url=&quot;http://www.thecodecage.com&quot;]Microsoft Office Help[/url]