Conditional formatting
Make the cells that matter stand out: thresholds, whole rows, duplicates and due dates.
Lessons
In the order the Roadmap teaches them.
In the full course. Confident · 8 min
Highlight cells above a value
Color every amount above a limit automatically, so the cells that need attention stand out and keep standing out when the numbers change.
See the lessonIn the full course. Confident · 9 min
Color scales and data bars
Color a grid of numbers from lowest to highest, so the strong and weak spots stand out at a glance.
See the lessonIn the full course. Confident · 9 min
Highlight the whole row
Color an entire row when one of its cells meets a condition, with a formula rule that locks the column it checks.
See the lessonIn the full course. Confident · 9 min
Highlight duplicates
Color every value that appears more than once in a column, so repeated invoices, emails or IDs stand out before they cause trouble.
See the lessonIn the full course. Confident · 11 min
Highlight overdue and due-this-week dates
Color overdue dates red and dates due within the next week yellow, with formula rules that compare each date to today.
See the lessonIn the full course. Confident · 10 min
Traffic-light status column
Color a status column green, yellow and red with one rule per status. Then you can see problems right away when a status changes.
See the lessonIn the full course. Confident · 9 min
Manage and remove rules
Find, change, extend and remove conditional formatting rules, and know which rule wins when two apply to the same cell.
See the lessonIn the full course. Advanced · 12 min
Rules with custom formulas
Write formula rules that compare cells in the same row, combine conditions with AND and OR, and handle empty cells.
See the lessonPaths with these lessons
A path is a short list of lessons from the course, picked for one goal.
Team trackers in Google Sheets
For tracking tasks, requests or projects in a shared sheet.
10 lessons · about 1 h 40 min · 1 free · Beginner to Confident
See the pathGoogle Sheets for small business
For quotes, stock and money kept in a spreadsheet.
12 lessons · about 2 h 15 min · 3 free · Confident
See the pathClean up messy data
For exports, CSVs and form responses that need tidying before anyone can use them.
10 lessons · about 1 h 30 min · 1 free · Beginner to Confident
See the pathGet the full course
Every lesson in the Google Sheets course, with new lessons added as they're written.
- All 215 Google Sheets lessons open today, and every new one as it's written.
- The Roadmap, Skills and all seven paths.
- A cheat sheet for every lesson you finish.
- At checkout, add the Excel course for US$49.