Last Updated on November 2, 2023 by Jake Sheridan
In this tutorial, you will learn how to use conditional formulas in Google Sheets
How To Use Conditional Formulas in Google Sheets
Google Sheets provides many built-in conditional formatting rules, such as “Greater than,” “Less than,” “Is equal to,” and “Text contains.” But sometimes, you may want to use a more complex formula to determine what cells to highlight in your range.
For example, you may want to highlight cells that have errors. Or, you may want to format cells that are a certain number of days overdue.
In this guide, we will show you how to use custom formulas for conditional formatting in Google Sheets.
How To Use a Custom Formula for Conditional Formatting in Google Sheets
Here’s how to use a custom formula for conditional formatting in Google Sheets.
First, select the range where you want to add conditional formatting.
In this example, we want to highlight rows in the range A1:F25 that have a transaction amount over $1,000.
Select the Conditional formatting option under the Format drop-down menu.
Click on the Format rules drop-down menu to reveal more options for conditional format rules.
Select the Custom formula is option found at the bottom of the drop-down list.
Next, type the custom formula you want to use in the textbox. In this example, we’ll look at the values in column D to see if they exceed 1000.
After typing the custom formula, you may now modify the formatting style for the current rule. Click on Done to proceed.
Your range should now have highlighted rows based on conditional formatting rules using custom formulas.
In this example, we were able to highlight rows with a transaction amount exceeding $1000.
This guide should be everything you need to use conditional formulas 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 Formatting Based On Another Cell Not Empty
- Conditional Formatting Based On Another Cell Date
- If Cell Contains Text in
- Highlight Cells
- Highlight Duplicate Cells
- Make Negative Numbers Red