Feature inner image credit: Samuel King Jr.
Google Sheets – Conditional Formatting
Conditional formatting in Google Sheets is a powerful and useful tool to change fonts and backgrounds based on certain rules.
This tutorial assumes that you already have a basic knowledge of Conditional Formatting but would like to uncover the mysteries of the Custom Formula option.
In this post, I will guide you through the steps to build your own custom formulas in oder to:
- Apply Conditional Formatting across a whole range based on a value in one or two columns.
- Apply Conditional Formatting across one column based on values in other columns.
Throughout the examples, we’ll look at various aspects of using Custom Formula to match, use formula functions and apply multiple conditions.
Before we hit the examples, let’s briefly go over accessing the Custom Formula in Google Sheet’s Conditional Formatting.