Forum Discussion
jnolan
Jun 26, 2020Copper Contributor
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.
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