Graham C1600
Board Regular
- Joined
- Feb 17, 2018
- Messages
- 96
- Office Version
- 365
I have a table such as below. I want the following conditional formatting conditions to be met.
Scenario 1 - If Cell B2 is = or > than today and Cell C2 is "Ongoing", Cells A2,B2,C2 need to be filled in Red.
Scenario 2 - If Cell B2 is = or < than today and Cell C2 is "Complete", Cells A2,B2,C2 need to be filled in Blue.
Scenario 3 - If Cell B2 is = or < 7 days than today and Cell C2 is "Ongoing", Cells A2,B2,C2 need to be filled in Amber.
Scenario 4 - If Cell B2 is = or < than today by more than 7 days and Cell C2 is "Ongoing", Cells A2,B2,C2 need to be filled in Green.
Hope this makes sense.
Thanks
What | Date | Status |
Test | 01/01/2023 | ongoing |
Test 1 | 18/01/2023 | Ongoing |
Test 2 | 11/01/2023 | Complete |
Scenario 2 - If Cell B2 is = or < than today and Cell C2 is "Complete", Cells A2,B2,C2 need to be filled in Blue.
Scenario 3 - If Cell B2 is = or < 7 days than today and Cell C2 is "Ongoing", Cells A2,B2,C2 need to be filled in Amber.
Scenario 4 - If Cell B2 is = or < than today by more than 7 days and Cell C2 is "Ongoing", Cells A2,B2,C2 need to be filled in Green.
Hope this makes sense.
Thanks