Conditional formatting with two variable inputs

Let’s take a look.

Here we have the example we looked at previously.

To make use of the second input, we’ll need to edit the formula.

I’ll create this test formula directly on the worksheet.

The easiest way to test for more than one condition is to use the AND function.

The AND function can handle multiple conditions and will return true only if all conditions return true.

Each condition is separated with a comma.

Because both of these conditions are TRUE, the AND function returns TRUE.

To apply conditional formatting with a formula, this is exactly what we want.

For conditional formatting, this is exactly what we want.

Just like before, we use AND with two conditions.

Once we update the rule, the new formula takes effect.