Hi
you may try the following formula
=AND(G32=DATE(2004,1,26),G32<=DATE(2004,2,25))

--
Regards
Frank Kabel
Frankfurt, Germany

mlm wrote:
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.