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