I don't know about 07, but with earlier versions it would be Formula Is
(rather than Cell Value Is) =$A1<NOW() (remembering the absolute reference
for the column, but not for the row).
--
David Biddulph

wrote in message
ups.com...
Hi all,
I'm after some help on conditional formatting in Excel 07.
I have data which I would like to format based on whether a condition
in the first cell in a row is met. This used to be easy in earlier
versions of excel but I cannot for the life of me work out how to do
it with 07. Here is an example of what I am trying to achieve:
if A1 < now() then format the entire A row.

Hope this makes sense!
Thanks in advance
Dave.