Color rows based on date relative to today

Unsolved

I have a sheet of tasks with missed deadlines by assigned person. I’d like the sheet to color each row (task) with red, orange, yellow, or green based on how many days late it is. So essentially: if date in cell A15 is 60 days older than today’s date, color row A red. Is this possible? And if so, how?

Posted Jun 19, 2024, 3:52 PM UTC

15
Loading comments…