test_man2
New Member
- Joined
- Aug 28, 2007
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
Greetings!
I have a spreadsheet with three date columns -
Released, Implemented, Activated
The Released date is 13 days before the Implemented date.
The Implemented date is six days before the Activated date
The Activated date is a hard-coded date of when this table began and then 14 days added to it for the next row in that column.
Formulas look like this: (A) Released: =B2-13; (B) Implemented: =C2-6; (C) Activated: row 2 is 5/20/2022, then subsequent rows are =C2+14, C3+14, etc.
Since the rows carry down to the end of the year (A:19 = 12/25), I'd like to conditionally format the rows in column A, B, and C to grey highlight where today's date has passed the date in column A to make it easier to find the most current date row that hasn't passed and help me see what has been activated. Currently, I have the conditional format as this: Formula: =A2 < TODAY() and it is applied to =$A$2:$C$19.
The weakness in this is that column A will be highlighted sometimes before column C.
How can I set the conditional formatting to highlight all three cells in that row but not highlight the next row until that date has passed? As you can see, the next A: date will have passed before C: date has.
I have a spreadsheet with three date columns -
Released, Implemented, Activated
The Released date is 13 days before the Implemented date.
The Implemented date is six days before the Activated date
The Activated date is a hard-coded date of when this table began and then 14 days added to it for the next row in that column.
Formulas look like this: (A) Released: =B2-13; (B) Implemented: =C2-6; (C) Activated: row 2 is 5/20/2022, then subsequent rows are =C2+14, C3+14, etc.
Since the rows carry down to the end of the year (A:19 = 12/25), I'd like to conditionally format the rows in column A, B, and C to grey highlight where today's date has passed the date in column A to make it easier to find the most current date row that hasn't passed and help me see what has been activated. Currently, I have the conditional format as this: Formula: =A2 < TODAY() and it is applied to =$A$2:$C$19.
The weakness in this is that column A will be highlighted sometimes before column C.
How can I set the conditional formatting to highlight all three cells in that row but not highlight the next row until that date has passed? As you can see, the next A: date will have passed before C: date has.
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| A2:A19 | A2 | =B2-13 |
| B2:B19 | B2 | =C2-6 |
| C3:C19 | C3 | =C2+14 |
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| A2:C19 | Expression | =A2<TODAY() | text | NO |
