This will work for a given date in G32 that identifies Month 1 for the
range G32 to AT32 filled with dates. Month 2 is defined as the month
following Month 1.

The remainder of your question is unintelligible. Cycle is meaningless to
me. Alternate colors from one month cycle to the next is meaningless to me.
Two conditionals alike? means nothing to me.

--
Regards,
Tom Ogilvy

"mlm" wrote in message
...
okay thanks,

Will this also work for when there is more than one cylce
ina range of cells? how do i apply this to alternate
clors from one month cycle to next?? two conditionals
alike?
-----Original Message-----
Select G32 to AT32 with G32 as the active Cell
Go to Format=Conditional formatting
change cell value is to formula is in the first dropdown

=And(G32=Date(year($G$32),month($G$32),26),G32<= Date
(Year($G$32),Month($G$3
2)+1,25))

or leave it as Cell Value is and use Between,
in the first condition =Date(year($G$32),month
($G$32),26)
in the second condition =Date(Year($G$32),Month($G$32)
+1,25)

Include the "=" sign.
--
Regards,
Tom Ogilvy


"mlm" wrote in message
...
Hello, What syntax can i use to highlight cells that
are
in the date range between of 26th of Month1 to 25th of
month2? Do i use in between or ....
I thought of using the AND suntax with month1 and 2 in
conditional formtting as a formula but cant seem to get
it down here. my range of cell is G32 thru AT32 with
the
g32 beingthe active cell.


.