Hi
I would like to create conditional formatting rules for a matrix i am completing.
The conditional formatting would require that:
if a due date falls 28 days or less from todays date - Green Highlight
If a due date falls 9 days or less from todays date - Orange Highlight
If a due date falls On todays date or todays date has passed - Red Highlight.
I also then need a rule that will ignore all three of these rules and change the cell to a different colour if a completion date is entered in a different cell.
I hope someone can help me with this.
Thank you in advance
Bookmarks