Color rows based on date relative to today
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