Hi!

Try this.....

Assume dates are in the range A1:A10

Select the range A1:A10
Goto FormatConditional Formatting
Formula is: =A1=TODAY()
Click the Format button and select the style you'd like
OK out

Biff

"Mike Echo" wrote in message
...
I have done this before but for the life of me cannot remember how I did
it.

Assume I have a column of dates. I want that column to be conditionally
formatted so that today's date will be red for example. I enter

=NOW()=1

in the formula for the conditional format but she no go. I tried TODAY
(), etc too.

Any ideas?

TIA,
R.