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 TaskAreaPriorityCompletedDue Date
wipe windowskitchenhigh☑11/10/2026
sweep floorsliving roomlow☐11/12/2026
polish door handlesbedroommedium☑11/14/2026
wipe windowsbathroomlow☐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.

← Back to the spreadsheets Hub