SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-1492124%22%20slang%3D%22en-US%22%3EConditional%20Formating%20IF%20A2%20has%20text%20and%20B2%20is%20blank%20set%20B1%20to%20red)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492124%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20number%20of%20data%20sets%20but%20I%20cannot%20solve%20this%20particular%20problem%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EI%20wish%20to%20colour%20the%20cell%20B2%20red%20if%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSTRONG%3EB2%20is%20blank%20AND%20A2%20contains%20any%20text%20entry.%26nbsp%3B%3C%2FSTRONG%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20will%20be%20applying%20this%20to%20a%20range%20of%20cells%20A2-A15%20and%20B2-B15%20and%20repeating%20it%20multiple%20times%20in%20other%20parts%20of%20the%20document%20to%20do%20the%20same%20check.%3C%2FP%3E%3CP%3EI%20just%20cannot%20work%20it%20out%20and%20have%20looked%20at%20multiple%20how%20to%20videos%20and%20searched%20posts%20and%20webpages%20but%20none%20meet%20the%20criteria%20I%20have%20listed.%26nbsp%3B%3C%2FP%3E%3CP%3EAHHHH%3C%2FP%3E%3CP%3EPlease%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1492124%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1492210%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formating%20IF%20A2%20has%20text%20and%20B2%20is%20blank%20set%20B1%20to%20red)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492210%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F245169%22%20target%3D%22_blank%22%3E%40jnolan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20use%20this%20formula%20in%20the%20conditional%20formatting%20formula%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DAND(ISBLANK(B2)%2CNOT(ISBLANK(A2)))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheck%20the%20attached%20document%20for%20guidance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1492226%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formating%20IF%20A2%20has%20text%20and%20B2%20is%20blank%20set%20B1%20to%20red)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492226%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622486%22%20target%3D%22_blank%22%3E%40wumolad%3C%2FA%3E%20I%20really%20appreciate%20that%20it%20worked%20wonders!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1492248%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formating%20IF%20A2%20has%20text%20and%20B2%20is%20blank%20set%20B1%20to%20red)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492248%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F245169%22%20target%3D%22_blank%22%3E%40jnolan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGlad%20to%20hear%20it%20worked.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20have%20a%20great%20weekend%20ahead.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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
Highlighted
Best Response confirmed by jnolan (Occasional Contributor)
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

Highlighted

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

Highlighted

@jnolan 

 

Glad to hear it worked.

 

Do have a great weekend ahead.

 

Cheers