![]() |
#1
|
|||
|
|||
![]()
I have a formula in B2 to display the date that appears in A2, plus 7 days. I typed "7" into Sheet 2, C2, and refer to that cell in the formula.
Now I would like to highlight B2, if today's date is more than 7 days past the date in A2. In other words, A2 = 6/1/14 B2 = 6/8/14 with formula: =IF(A2="","",(SUM(A2+Sheet2!$C$2))) Today's date is 6/27/14, so B2 needs to be highlighted in red. Is there any way to do that? Thanks! |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting with Dates | namedujour | Excel | 1 | 02-21-2013 03:42 AM |
Conditional formatting | zanat0s | Excel | 4 | 01-20-2012 03:30 AM |
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell | Frogggg | Excel | 1 | 10-25-2011 08:44 PM |
![]() |
Lucky | Excel | 2 | 10-03-2011 11:41 PM |
![]() |
Snvlsfoal | Excel | 3 | 07-03-2011 11:55 PM |