Conditional Formating IF A2 has text and B2 is blank set B1 to red)

[jnolan]

I have a number of data sets but I cannot solve this particular problem:

I wish to colour the cell B2 red if:

• B2 is blank AND A2 contains any text entry. 

I will be applying this to a range of cells A2-A15 and B2-B15 and repeating it multiple times in other parts of the document to do the same check.

I just cannot work it out and have looked at multiple how to videos and searched posts and webpages but none meet the criteria I have listed. 

AHHHH

Please help. 

[#2 · Accepted solution]

Hi @jnolan 

You can use this formula in the conditional formatting formula

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

Check the attached document for guidance.

Cheers

[#3]

Thank you @wumolad I really appreciate that it worked wonders!

[#4]

@jnolan 

Glad to hear it worked.

Do have a great weekend ahead.

Cheers