Interactive Tutorial
How to Apply Conditional Formatting in Google Sheets
4.9 out of 5 on G2
Practice live in your browser. No software required.
4 Hour Course Certificate
Free quick tips and shortcuts to use and share.
Step-by-step instructions with screenshots.
You can apply certain formatting to cells that meet criteria that you set. This is called conditional formatting.
The Conditional format rules pane appears, and a new rule has been started.
The rule is saved.
The rule is deleted.