Hello,

In cell A2, I have coded the formula "=NOW()". Sometimes I have to
hardcode a date from an earlier month in this cell. I wanted to use
conditional formatting to warn me with a color that the cell contains a
hardcoded date rather than "=NOW()", in case I forget to set the cell
back to "=NOW()". Does anyone know how I can use conditional
formatting to tell me either, that the cell has a hardcoded date, or,
that the formula "=NOW()" is not present in the cell. I've tried
different things and nothing has worked.

Thanks,

Carroll Rinehart

I figured something out so no longer need help. I used "Formula IS"
=NOT(AND(MONTH(A2)=MONTH(NOW()),YEAR(A2)=YEAR(NOW( )),DAY(A2)=DAY(NOW()))).
The cell turns a color if not set to NOW(), or at least to a date
value equal to NOW().

Thanks anyway!

Carroll Rinehart

Your formula has eliminated the time component in the
comparison, so that formulas will work. But for your normal
use you probably want to use =TODAY() instead of =NOW()

"Carroll" wrote in message oups.com...
I figured something out so no longer need help. I used "Formula IS"
=NOT(AND(MONTH(A2)=MONTH(NOW()),YEAR(A2)=YEAR(NOW( )),DAY(A2)=DAY(NOW()))).
The cell turns a color if not set to NOW(), or at least to a date
value equal to NOW().

Thanks anyway!

Carroll Rinehart

Thanks!