spreadsheets Hub

How Conditional Formatting Helps You See Completed Tasks

Checking off a finished chore is satisfying, but a long household task list can still be difficult to scan. Highlighting completed tasks makes your progress easier to see without removing anything from the list.

The Real Question

How can I make completed tasks stand out in a spreadsheet? Can finished chores change color automatically? How can I see my progress without deleting completed items?

The practical question is: How can I automatically highlight an entire household task when I check its completion box?

Answer Sheets

Google Sheets Conditional Formatting can highlight an entire task row whenever its checkbox is checked, making completed work immediately recognizable.

And here's what that looks like for me. In my Household Tasks tab, I use the existing Completed checkboxes to control which rows are highlighted:

Household TaskAreaPriorityCompleted
wipe windowskitchenhigh☑
sweep floorsliving roomlow☐
polish door handlesbedroommedium☑
wipe windowsbathroomlow☐
1. Select the Completed checkbox cells.

2. Choose Format > Conditional formatting.

3. Under Format cells if, choose Is equal to.

4. Enter TRUE.

5. Choose a highlight color.

6. Click Done.

7. Check or uncheck a box to see its cell change color.

Now I can see my completed chores highlighted across the entire row, and the highlighting disappears when I reset a checkbox for another cleaning session.

Put Conditional Formatting On Your Tracker

  • Artists, Makers, and Crafters. Highlight completed steps in creative projects.
  • Caregiver Managers. Distinguish completed routine activities from unfinished ones.
  • Content Creators. Highlight finished production and publishing tasks.
  • Household Managers. Make completed household chores easy to recognize.
  • Solo/Micro Landlords. Highlight finished property maintenance tasks.
  • Students and Independent Researchers. See completed project activities at a glance.
  • Teachers and Tutors. Highlight finished lesson preparation tasks.

← Back to the spreadsheets Hub