Set up conditional formatting in dates, with additional variants
I know how to set the conditional formatting to have a date cell turn red when the task is due in the next X days (for example). But is there a way to do it only if the Status (another column) is not in "Complete"?
So something like: If Status is "In progress", "In review", or "Not Started", AND Due Date is in the next 2 days, turn Due Date column red.
Is this possible?
Help Article Resources
Check out the Formula Handbook template!