Conditional Formatting to Test Value in Cell

[Carroll]

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

 

[Carroll]

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

 

[David McRitchie]

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]

Thanks!