Pro lesson · 8 exercises · first one free
Highlight with Conditional Formatting
About this lesson
Colour cells and rows automatically, with the built-in rules and with your own formula.
Statistics, charts and tables · 8 short exercises in a live spreadsheet: you type each formula yourself and answer questions that make you predict results or spot bugs. Every answer is checked instantly.
What you'll practise
- Writing a rule formula that returns TRUE
- Predicting which cells a rule formats
- Typing a rule that colours whole rows
- Colouring rows by a text status
- Combining two conditions in one rule
- Highlighting duplicate values without a formula
- Knowing that formatting follows the value
- Opening the rules to edit or remove them
Functions you'll use
Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 8, no account needed.
Pro lesson
Unlock the whole lesson
Pro unlocks every lesson, the case studies and unlimited weak-spot review. The fundamentals track stays free.