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