Use a formula of

=AND(A1=DATE(YEAR(TODAY()),MONTH(TODAY())-2,DAY(TODAY()))<A1<=TODAY())

where A1 is the first cell to be CFed.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dee" wrote in message
...
I want to put conditional formatting into a cell where I want excel to
change
the color of the date in the cell if it date is anywhere between today's
date
and 2 months prior to today's date.

So if today's date is August 12th and the date in the cell is anywhere
between June 12th and August 12th the cell will change color. I am using
Excell 2003

Thanks very much for your help.

Best regards,

Dee