Thread: Trying to create an overdue message based on set dates
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Trying to create an overdue message based on set dates
I second Suleman's suggestion.
If you have these dates, starting at A1
1/1/2007 1/14/2007 1/29/2007 2/13/2007
enter this conditional format formula for A2:A4
=DATEDIF($A$1,B$1,"d")(COLUMN()-1)*14
Cell D3 should turn red.
Reply With QuoteReply With Quote