Thread: Have a date chane if it is +/- 2 days from the previous date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gohan51D
 
Posts: n/a
Default Have a date chane if it is +/- 2 days from the previous date

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


--
Gohan51D
------------------------------------------------------------------------
Gohan51D's Profile: http://www.excelforum.com/member.php...o&userid=32274
View this thread: http://www.excelforum.com/showthread...hreadid=521228

Reply With QuoteReply With Quote