Conditional formating two criteria

[alipezu]

Hi All,
I have a table consists of two columns A and B.
Now my question is how can I get the cells red If column A is not blank and column B is blank.
Thank you.

[Glenn Kennedy]

Here's one way. use this as the CF formula:

=AND(ISBLANK(B2),NOT(ISBLANK(A2)))

[José Augusto]

Or
=AND(ISBLANK(Table1[@Age]),NOT(ISBLANK(Table1[@Name])))

[Pete_UK]

Select cells B2 to B8, click on Conditional Formatting | New Rule | Use a Formula... , then enter this formula in the dialogue box:

=AND(A2<>"",B2="")

Click on the Format button | Fill tab and choose red, then click OK twice to exit the dialogue box - Excel will adjust the cell references to suit all the cells that were selected, so you only have to do this once.

Hope this helps.

Pete

[alipezu]

That was helpful. thank you!