I want to create a conditional rule on the following table that will color column E in the following ways:
If Column D is <= TODAY = Green
If Columns D is >TODAY < TODAY +14 = Yellow
If Column D is >TODAY +14 = Red
I am not sure how to do this and I need to be apply to multiple worksheets. The cell in column E should follow the rules even if it is blank. I worked it out once the dates are filled in, but would like to do it even if they are blank
If Column D is <= TODAY = Green
If Columns D is >TODAY < TODAY +14 = Yellow
If Column D is >TODAY +14 = Red
I am not sure how to do this and I need to be apply to multiple worksheets. The cell in column E should follow the rules even if it is blank. I worked it out once the dates are filled in, but would like to do it even if they are blank
Collect Updates From Business (C) | D | E |
Expected Start Date | Expected End Date | Rec'd From Owner |
12/16/2022 | 1/20/2023 | |
12/16/2022 | 2/3/2023 | |
12/16/2022 | 1/20/2023 | |
12/16/2022 | 1/20/2023 | 01/19/23 |
12/16/2022 | 2/3/2023 | |
12/16/2022 | 2/3/2023 | |
12/16/2022 | 2/17/2023 | |
12/16/2022 | 1/20/2023 | |
12/16/2022 | 2/17/2023 | |
12/16/2022 | 2/17/2023 |