conditional formatting - compare 2 dates

D

Dan

I would like to use conditional formatting to highlight cells. Here is the
scenerio .. a cell has a date that is calculated from a formula. If that
date falls within the next 7 days i would like the cell to change colors. I
for the life of me can not figure out the correct formula to put into the
conditional formatting box.

Thanks in advance.
 
B

Bob Phillips

Assuming that the dates start in A!, select all the cells and use this
formula

=AND(A1>=TODAY(),A1<TODAY()+7)

--

HTH

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