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

=MONTH(E$2)=MONTH(TODAY())

try the above formula. Conditional formating is just looking for a TRUE or
FALSE value, so there is no need for the IF part.

"Todd" wrote:

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

lets try to minimize the use of today() or Now() in the conditional format
formula..
place in a specific secure cells the following
(e.g. )
IV1 = month(now())
IV2 = year(now())

then on conditional format

e.g Column A contains list of dates

on cell A1 <if month and year sensitive

formula is: =and(MONTH(A1)=$IV$1,YEAR(A1)=$IV$2)
pick your color font/pattern

if it is only MONTH sensitive, regardless of the year
formula is: =MONTH(A1)=$IV$1
pick your color font/pattern

maybe
--
*****
birds of the same feather flock together..



"Todd" wrote:

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

One mo

=AND(E$2<"",MONTH(E$2)=MONTH(TODAY()))

Just in case E$2 is empty.

Todd wrote:

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

--

Dave Peterson