Conditional formatting based on a different cell

Let’s take a look.

The easiest way to apply conditional formatting is to apply rules directly to the cells you want to format.

Start by selecting the cells you want to format.

For the formula itself, start with an equal sign.

Then add the logical test you need.

In this case, we can use H6 < 80.

This will return true when the average is less than 80 and trigger the rule.

Note that H6 corresponds to the active cell in this selection, which is B6.

Now, if I don’t need the first rule, I can simply remove it.

This example is quite simple example, but the approach is the same for more complex rules.

First, grab the cells you want to format.

Then enter a formula that will return TRUE for conditions you’re testing.