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

  • Thread starter Thread starter Gohan51D
  • Start date Start 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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting - Difference between dates 5
Excel Message box with days of month & date. 1
Add 45 days to a date.... 3
How do a set the current date to change in cell everyday 1
Comparing Dates 4
Using Dates with the IF function 2
Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1
Count number of cells of a particular month in a column of dates 9

Back
Top