close
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: www.excelforum.com/member.php...oamp;userid=32274
View this thread: www.excelforum.com/showthread...hreadid=521228You can do that with conditional formatting. Set the condition to
quot;Formula Isquot; and use this formula:
=ABS(B1-A1)lt;=2
....where A1 and B1 contain the dates.
全站熱搜
留言列表
