How to highlight rows using multiple criteria

Here we have an example we looked at previously.

But what if we want to highlight rows based on both priority and owner?

In that case, we’ll need to extend the formula to handle 2 conditions.

First, I’ll add an input cell for priority.

I’ll call the first input “priority” and the second input “owner”.

Now we can use a formula that evaluates two conditions inside the AND function.

When I update the rule, I can now highlight both a priority and an owner.

But notice that I can’t highlight just priority, or just owner.

To fix this, we can use the OR function together with the AND function.

And if column D = owner, OR, if owner is blank, return true.

When I update the formula, we can highlight based on priority, or owner, or both.

However, we now have one final problem.

If both priority and owner are blank, all rows are highlighted.

Now we can highlight based on priority, or owner, or both.

And when both inputs are blank, no roes are highlighted.