Thread: Formating a row based on one cell's date
View Single Post
  #11   Report Post  
Spencer101 Spencer101 is offline
Senior Member
  
Posts: 663
Default
Quote:
Originally Posted by Tee51 View Post
The current formula is highlighting 7 days before and after today. Is there anyway to highlight only 7 days before?
Just add another condition to the AND....

=AND($A1=TODAY()-6,$A1<=TODAY(),$F1<"Closed")
Reply With QuoteReply With Quote