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