How to use Google sheets conditional formatting based on another cell?

When you use Google Sheets on a daily basis, you might end up in need of use Google sheets conditional formatting based on another cell.

Here I collected some examples for conditional formatting based on another cell, this will make it more clear for you, and hopefully it will be useful for your needs.


It is all about conditional formatting

conditional formatting allows you to automatically apply formatting—such as colorsicons, and data bars—to one or more cells based on the cell value.

To do this, you’ll need to create a conditional formatting rule.

For example, a conditional formatting rule might be: If the value is less than $2000, color the cell red.

By applying this rule, you’d be able to quickly see which cells contain values less than $2000.

Let’s get to the point.

How to use Google sheets conditional formatting based on another cell?

In the first example, I will go for a showcase of how to highlight cells of students’ score tests with a score of less than 50 in red and with more than 82 in green.

list of random numbers

This first need is easy to do. we use the simple way of conditional formating.

conditinal-formating-first step

Here we make less than 50 to red color:


And in the next step,  more than 82 to the green color:

more than 82

That was easy! 😀

How to Highlight a cell based on another cell in Google Sheets?

In this case, I want to change the color of the name, that didn’t pass Math exams to blue.

I am going again to conditional format rules, and click on “customer formula is”

blue-b2 (1)

I used the simple way and just asking for a change in the color of cell A2 when B2 is less than 50.

First, we can apply the same formula, to all ranges.

Second, we can add more conditions to that.



Finally, we have the results for conditional formatting:


All in one GIF:

conditional formatting

Did you get an answer to your question? If not, leave me a comment.