So I have this report with 3 columns of dates. Created, Complete, and Due. I need to:
1. Highlight a cell in column D (Completed) if that date is more than 10 working days more than the date in column C (Created)
And
2. Highlight a cell in column D (Completed) if that date is after the date in Column E (Due)
If both above rules apply I'd like the color of the highlighted cell to be a 3rd color, different from whatever color I pick to highlight rule 1 or rule 2.
Screen Shot 2019-10-02 at 5.23.04 PM.png
Any help would be greatly appreciated. Happy to share the actual excel file. Thanks
Bookmarks