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<=D ate(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.