Conditional Formatting Based On Another Cell in Google Sheets – 3 Easy Steps

Reading Time: 3 minutes
Conditional formatting based on multiple cell values

Objective

Learn about how to use Conditional Formatting based on another cell and other variations around it.

Why use Conditional Formatting based on another cell?

When you’re working with huge tables, all the data can be very overwhelming. Google Sheets provides you with conditional formatting, which helps you visualize data using colours. You can manually add conditions while formatting the data. This helps you in analysing in a better and more efficient way.

Conditional Formatting Based On Another Cell Value Using the Formatting Menu

Step 1: Select the cells you want to highlight

  • Open Google Sheets.
  • Select the column of cells you want to highlight.
Select the column of cells
Figure 1: Select the column of cells

Step 2: Open Conditional Formatting

  • Navigate to the Format button in the menu bar. Select Format.
  • Click on Conditional Formatting.
Open conditional formatting
Figure 2: Open conditional formatting

Step 3: Modify conditional formatting rules

  • Go to the Single Colour tab.
  • Also, make sure that the range mentioned in the “Apply to range” tab is the same as the range on which you want to apply conditional formatting.
  • Now go to Format Rules and then select Custom formula is.

Open custom rules
Figure 3: Open custom rules
  • In the formula field, enter your custom formula.

Apply custom formula
Figure 4: Apply custom formula
  • Navigate to Formatting Style and select the colour of your choice.
  • Select Done.
Conditional formatting based on another cell value
Figure 5: Conditional formatting based on another cell value

Conditional Formatting Based on Multiple Another Cell Values Using the Formatting Menu

Step 1: Select the cells you want to highlight

  • Open Google Sheets.
  • Select the column of cells you want to highlight.
Select column of cells
Figure 6: Select column of cells

Step 2: Open Conditional Formatting

  • Navigate to the Format button in the menu bar. Select Format.
  • Click on Conditional Formatting.
Select conditional formatting
Figure 7: Select conditional formatting

Step 3: Modify conditional formatting rules

  • Go to the Single Colour tab.
  • Also, make sure that the range mentioned in the “Apply to range” tab is the same as the range on which you want to apply conditional formatting.
  • Now go to Format Rules and then select Custom formula is.
Select format rules
Figure 8: Select format rules

  • Since you want to apply formatting based on multiple cell values, use the OR function.
  • In the formula field, enter your custom formula, as shown below:
Apply custom formula
Figure 9: Apply custom formula
  • Navigate to Formatting Style and select the colour of your choice.
  • Select Done.
Conditional formatting based on multiple cell values
Figure 10: Conditional formatting based on another cell values

See Also

Conditional Formatting in Google Sheets| Quick Guide: Get started with Conditional Formatting in Google Sheets.

shalinamigo

←
→

Leave a Reply