is there a way to do a conditional format for whenever a
date changes to the next month to change color?

I have a row of columns which is set up for 60 days.
(2months) i would like for one to start out as color
chosen then chnage as the month changes? i would do a
normal format but then again there isnt 30 days every
month.

assume your first cell with a date is C22

select C22 to BJ22 (C22 is the active cell)

format = conditional formatting

Formula is
=month($C$22)<Month(C22)

then set your formatting

click OK

--
Regards,
Tom Ogilvy


"mlm" wrote in message
...
is there a way to do a conditional format for whenever a
date changes to the next month to change color?

I have a row of columns which is set up for 60 days.
(2months) i would like for one to start out as color
chosen then chnage as the month changes? i would do a
normal format but then again there isnt 30 days every
month.

tom ..i put in what you said ..
it seem to do nothing.

i have cells G32 thru AT 32 as date cells. I put int he
formula as exact and without the = sign since it adds it
once ok'd..did i miss somehting somewhere??? or??

thanks.

-----Original Message-----
assume your first cell with a date is C22

select C22 to BJ22 (C22 is the active cell)

format = conditional formatting

Formula is
=month($C$22)<Month(C22)

then set your formatting

click OK

--
Regards,
Tom Ogilvy


"mlm" wrote in message
...
is there a way to do a conditional format for whenever
a
date changes to the next month to change color?

I have a row of columns which is set up for 60 days.
(2months) i would like for one to start out as color
chosen then chnage as the month changes? i would do a
normal format but then again there isnt 30 days every
month.


.

If your dates don't span two months, then it won't do anything. If they do,
it will shade the second month. This matches your description. the first
month would be the normal cell color and the second month would be the
conditionally formatted cell color.

If it doesn't work for you, then you have done something wrong. It worked
fine for me.

--

Regards,
Tom Ogilvy



"mlm" wrote in message
...
tom ..i put in what you said ..
it seem to do nothing.

i have cells G32 thru AT 32 as date cells. I put int he
formula as exact and without the = sign since it adds it
once ok'd..did i miss somehting somewhere??? or??

thanks.

-----Original Message-----
assume your first cell with a date is C22

select C22 to BJ22 (C22 is the active cell)

format = conditional formatting

Formula is
=month($C$22)<Month(C22)

then set your formatting

click OK

--
Regards,
Tom Ogilvy


"mlm" wrote in message
...
is there a way to do a conditional format for whenever
a
date changes to the next month to change color?

I have a row of columns which is set up for 60 days.
(2months) i would like for one to start out as color
chosen then chnage as the month changes? i would do a
normal format but then again there isnt 30 days every
month.


.