I put a time value in A1 then selected A2, went into conditional formatting
and selected Formula Is and entered:

=$A$1<NOW()

and set the cell background to change to red if the condition is true. Cell
A2 turned red as expected.

I also created a conditional format in A1 for the same condition. In
conditional formatting, I selected Cell Value Is, selected less than, then
inserted the following:

="NOW()"

and set the background to change to red. This turned A1 red as expected.

HTH
Mike
--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh

"Scott" wrote in message
...
Hopefully im in the right section for this question.

Is it possible to base a conditional format on the =Now()
expression? Basicly if the time is before or after the
time, I want the conditional formatting to return a
specific color. Ive tried =A1NOW() and set A1 to display
time, but I cant seem to get it to work. Thanks for the
help.