software

Hello,

In cell A2, I have coded the formula quot;=NOW()quot;. 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 quot;=NOW()quot;, in case I forget to set the cell
back to quot;=NOW()quot;. Does anyone know how I can use conditional
formatting to tell me either, that the cell has a hardcoded date, or,
that the formula quot;=NOW()quot; is not present in the cell. I've tried
different things and nothing has worked.

Thanks,

Carroll RinehartI figured something out so no longer need help. I used quot;Formula ISquot;
=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 RinehartYour 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()

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