Tag: AND

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:

1. Apply Conditional Formatting across a whole range based on a value in one or two columns.
   1. Example 1: Conditional Formatting a Whole Range Based on One Column’s Cell Values.
   2. Example 2: Conditional Formatting a Whole Range Based on Selected Values and Formulas.
   3. Example 3: Conditional Formatting a Whole Range Based on Multiple Column Values.
2. Apply Conditional Formatting across one column based on values in other columns.
   1. Example 4: Conditional Formatting of a single range Based on Another Column Value.
   2. Example 5: Conditional Format a single column range based on a value in another column – Multiple times.
   3. Example 6: Conditional Formatting a Single Column Based on Two Values.

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.

Continue reading “Google Sheets: Conditional Formatting with Custom Formula”