Conditional Formatting based on two different cell values

Question

I want to color a specific cell if (for example):

• A1 has a value (meaning it is not blank)
• B1 has no value (meaning it is blank)

In this scenario I would like to color B1 red. I want the formula to apply to the entirety of the B-column.

Solution

Try clicking Format > Conditional formatting > Custom formula is:

=AND($A1<>"";$B1="")

Apply this to range B:B and select a red colour format