Have a date chane if it is +/- 2 days from the previous date

G

Gohan51D

I have a spreadsheet of dates that track visits. The visits are
supposed to be 7 days appart but +/- 2 days is acceptible. Is there a
way to change the backround color of the cell if the date is +/- 2 days
from the date in the previous cell.

Gohan51D
 
D

Dave O

You can do that with conditional formatting. Set the condition to
"Formula Is" and use this formula:
=ABS(B1-A1)<=2
....where A1 and B1 contain the dates.
 
Top