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.
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.
Next, click on the Conditional formatting option under the Format menu.
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.
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.
You should now have a table that highlights cells based on whether a certain column is left empty.
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.
More ways to do conditional formatting Google Sheets:
- Remove Conditional Formatting
- How To Do Conditional Formatting
- Copy Conditional Formatting
- Conditional Formatting Based On Another Cell
- Conditional Formatting for Duplicates
- Conditional Formatting with a Checkbox
- Conditional Formatting with Multiple Conditions
- Conditional Formatting Based On Another Sheet
- Apply Conditional Formatting Across An Entire Row
- Conditional Formatting to Compare Two Columns
- Conditional Data Validation
- Color Scale Based On Another Cell
- Relative Reference
- Conditional Formulas
- Conditional Formatting Based On Another Cell Date
- If Cell Contains Text in
- Highlight Cells
- Highlight Duplicate Cells
- Make Negative Numbers Red