Forum Discussion
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 rang...
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
