Mike,
Don't know why you are comparing the date to 1 but you are correct it
realising you need to force a True/False result. In this instance, you need
to determine whether the cell has today's date it in, so select all of the
cells, starting at A1 say, and use a formula of
=A1=TODAY()
--
HTH
Bob Phillips
"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.
|