Dee,

As far as I can see, you are comparing two identical formula, so it will
always resolve to true, so always be red. Just strip it back to one test

=AND(F3>=DATE(YEAR(TODAY()),MONTH(TODAY())-2,DAY(TODAY())),F3<=DATE(YEAR(TOD
AY()),MONTH(TODAY())+2,DAY(TODAY())))

--

HTH

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


"Dee" <Dee@discussions.microsoft.com> wrote in message
news:3E33C36C-16DF-4076-A83A-0705621ED994@microsoft.com...
> Hi Bob,
>
> The formula is:
>
=AND(F3>=DATE(YEAR(TODAY()),MONTH(TODAY())-2,DAY(TODAY())),F3<=DATE(YEAR(TOD
AY()),MONTH(TODAY())+2,DAY(TODAY())))=AND(F3>=DATE(YEAR(TODAY()),MONTH(TODAY
())-2,DAY(TODAY())),F3<=DATE(YEAR(TODAY()),MONTH(TODAY())+2,DAY(TODAY())))
>
> If I change the cell to a different retest date that is say 6 months from
> today, the cell remains red in color. Should it not change to the default
> black?
>
> Thanks very much for your help.
>
> Regards,
>
> Dee
>
> "Bob Phillips" wrote:
>
> > It should work okay. What is the formula, and do you have manual
calculation
> > set?
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Dee" <Dee@discussions.microsoft.com> wrote in message
> > news:B3B4F269-9A99-4D43-B296-C5958910AE0E@microsoft.com...
> > > I have a formula in Conditional formatting that changes the color of
the
> > cell
> > > if a date in that cell is equal to today's date less 2 months and
todays
> > date
> > > plus 2 months. This works fine thanks to you guys helping me with the
> > > formula. However, if I change the date in the cell because there is
now a
> > new
> > > retest date and the date is more than 2 months, the cell stays red.
How
> > can I
> > > get the cell to change to a different color if I put in a new date
that
> > does
> > > not meet the criteria.
> > >
> > > Thanks again for any help.
> > >
> > > Best regards,
> > >
> > > Dee
> >
> >
> >