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:
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:
I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*
*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.