Jun 26 2020 07:14 AM
I have a number of data sets but I cannot solve this particular problem:
I wish to colour the cell B2 red if:
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.
Jun 26 2020 07:35 AM
SolutionHi @jnolan
You can use this formula in the conditional formatting formula
=AND(ISBLANK(B2),NOT(ISBLANK(A2)))
Check the attached document for guidance.
Cheers
Jun 26 2020 07:41 AM
Thank you @wumolad I really appreciate that it worked wonders!
Jun 26 2020 07:49 AM
Jun 26 2020 07:35 AM
SolutionHi @jnolan
You can use this formula in the conditional formatting formula
=AND(ISBLANK(B2),NOT(ISBLANK(A2)))
Check the attached document for guidance.
Cheers