conditional formatting formula part 2

Hi Expert's

need a formula so if cell a2=12 and cell b2 is blank then cell c3 is greyed out..m
route217Asked:
Who is Participating?
 
Sasha KranjacConnect With a Mentor Commented:
I think the formula should be:

=AND(A2=12;B2="")
0
 
NBVCConnect With a Mentor Commented:
Try:

=AND(A2=12,B2="")
0
 
NBVCCommented:
That is only in some versions of Excel based on your Regional Settings (Country)
0
 
Sasha KranjacCommented:
Forgot to say that it applies to English (UK) version/settings. If comma is not working try semicolon instead.
Thanks for pointing it out.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.