spreadsheets Hub
How Conditional Formatting Helps You Spot Overdue Tasks
It's easy to overlook a household task when its due date is buried among other entries. Highlighting overdue dates can make unfinished work easier to notice before it slips further behind.
The Real Question
How can I identify overdue household tasks? Is there a way to highlight dates that have already passed? How can I see which unfinished chores need attention?
The practical question is: How can I automatically highlight overdue dates for household tasks that aren't finished?
Answer Sheets
Google Sheets Conditional Formatting can highlight overdue dates when they are earlier than today and their corresponding tasks remain unfinished.
And here's what that looks like for me. I've added a Due Date column to my Household Tasks tab, alongside the task, area, and completion columns:
| Household Task | Area | Priority | Completed | Due Date |
|---|---|---|---|---|
| wipe windows | kitchen | high | ☑ | 11/10/2026 |
| sweep floors | living room | low | ☐ | 11/12/2026 |
| polish door handles | bedroom | medium | ☑ | 11/14/2026 |
| wipe windows | bathroom | low | ☐ | 11/20/2026 |
1. Add a Due Date heading in column D.
2. Enter the appropriate due dates.
3. Select D2:D.
4. Choose Format > Conditional formatting.
5. Under Format cells if, choose Custom formula is.
6. Enter:
=AND(ISNUMBER(D2),D2<TODAY(),C2=FALSE)
7. Choose a highlight color.
8. Click Done.
Now I can spot unfinished tasks with overdue dates at a glance, while completed tasks remain unhighlighted.
Set Conditional Formatting On Work Due Dates
- Caregiver Managers. Highlight overdue administrative and care-related tasks.
- Consultants. Identify unfinished client deliverables past their deadlines.
- Household Managers. Spot overdue chores and maintenance tasks.
- Online Sellers and Resellers. Highlight overdue inventory-related tasks.
- Solo/Micro Landlords. Identify unfinished property tasks past their due dates.
- Students and Independent Researchers. Spot overdue project milestones.
- Teachers and Tutors. Highlight unfinished lesson preparation tasks.