Thread: Conditional Formatting - Difference between dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gohan51D
 
Posts: n/a
Default Conditional Formatting - Difference between dates

If A1 is a date and B1 is a date. B1 is always scheduled to be 7 days
after A1 but can be +/- 2 days. I need to hilight B1 when it is out of
the +/- 2 day window with out hilighting empty cells.

Thanks
Gohan51D


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

Reply With QuoteReply With Quote