Google Sheets: Conditional Formatting
Conditional formatting is a powerful tool that helps you to highlight cells that meet a certain value. You can format cells, that contains:
- date ranges
- Number ranges or specific numbers
- Exact text or partial text
Once you have identified your condition you can change the cell’s background colour, font-weight or font colour.
You can access conditional formatting in Google Sheets by going to Format > Conditional formatting. Make sure you select the range you want to format first, though.
In this video tutorial we will cover the basics of Conditional Formatting in Google Sheet:
- What is conditional formatting and how to use it.
- Basics of conditional formatting.
- Example 1: Conditional Formatting Grade Ranges 0:23
- Example 2: Conditional Formatting empty cells or cell only containing values. 4:36
- Example 3: Conditional Formatting text that contains certain words or letters. 6:06
If you are keen to follow along here is a link to the Google Sheet I was working in:
Unformatted template to follow along with the video.
Simply, go to File > Make a copy to have your own copy of the file.
If you want to create custom conditions that are not in the list you really should check out this tutorial:
If you want to check out more on my Google Sheets Beginners course you can check the playlist out here:


~Yagi