Hi.

I would like a conditional format set to turn a data entry column a color if
it is in the right month. I tried =IF(MONTH(E$2)=MONTH(TODAY()),) but its
not working. I am guessing that its because today() is volatile. Is there a
way to do this?

Thanks,


Todd