Forum Discussion

jnolan's avatar
jnolan
Copper Contributor
Jun 26, 2020
Solved

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

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. 

3 Replies

Resources