Conditional Formatting Based On Another Cell Not Empty in Google Sheets

Last Updated on November 2, 2023 by Jake Sheridan

In this tutorial, you will learn how to apply conditional formatting based on another cell not empty in Google Sheets.

Conditional Formatting Based On Another Cell Not Empty in Google Sheets

Conditional formatting is a powerful tool that can highlight cells in a spreadsheet based on certain conditions. This can be helpful if you want to quickly see which cells contain data, for example.

One use case for conditional formatting is to format a cell based on whether another cell is empty. This can be helpful if you want to make sure that all of the data in a column is filled out, for example.

In this guide, we will show you how to use conditional formatting to format a cell based on whether another cell is empty.

How To Highlight Cells Based on Non-Empty Cells in Google Sheets

Here’s how to highlight cells based on non-empty cells in Google Sheets.

Step 1

First, select the range of cells you want to highlight with conditional formatting.

In this example, we’ll highlight the range A2:H22. We want to highlight rows where the grade column is left empty.

Step 2

Next, click on the Conditional formatting option under the Format menu.

Step 3

In the Conditional format rules panel, select the Custom formula is option from the dropdown menu.

This option will allow us to create the criteria needed to highlight cells if a certain cell is not empty.

Step 4

Next, we’ll set the custom formula for our conditional formatting. In this example, we’ll use the formula ‘=$H2=””’ to highlight rows that are empty.

Next, you may edit the formatting style used to highlight cells. Click on Done to proceed.

Step 5

You should now have a table that highlights cells based on whether a certain column is left empty.

Summary

This guide should be everything you need to apply conditional formatting based on another cell not empty in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.