14.4 C
London
Monday, July 7, 2025
HomeSoftware TutorialsGoogle SheetsGoogle Sheets: Conditional Formatting with Multiple Conditions

Google Sheets: Conditional Formatting with Multiple Conditions

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

You can use the custom formula function in Google Sheets to apply conditional formatting to cells based on multiple conditions.

The following examples show how to use the custom formula function in the following scenarios:

1. Conditional Formatting with OR logic

2. Conditional Formatting with AND logic

Let’s jump in!

Example 1: Conditional Formatting with OR Logic

Suppose we have the following dataset in Google Sheets:

Suppose we’d like to highlight each of the cells in the Team column where the name is “Spurs” or “Rockets.”

To do so, we can highlight the cells in the range A2:A11, then click the Format tab, then click Conditional formatting:

In the Conditional format rules panel that appears on the right side of the screen, click the Format cells if dropdown, then choose Custom formula is, then type in the following formula:

=(A2="Spurs")+(A2="Rockets")

Once you click Done, each of the cells in the Team column that are equal to “Spurs” or “Rockets” will automatically be highlighted:

Example 2: Conditional Formatting with AND Logic

Suppose we’d like to highlight each of the cells in the Team column where the name is “Spurs” and corresponding value in the Points column is greater than 15.

In the Conditional format rules panel, click the Format cells if dropdown, then choose Custom formula is, then type in the following formula:

=AND(A2="Spurs", B2>15)

Once you click Done, each of the cells in the Team column that are equal to “Spurs” and where the corresponding value in the Points column is greater than 15 will automatically be highlighted:

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Replace Text in Google Sheets
How to Replace Blank Cells with Zero in Google Sheets
How to Use a Case Sensitive VLOOKUP in Google Sheets
Google Sheets: Conditional Formatting if Another Cell Contains Text

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories