conditional formatting formula

Hi Expert's

Need a conditional formatting formula is if cell a2 and cell b2 are blank then grey out cell c3
route217Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Danny ChildConnect With a Mentor IT ManagerCommented:
Select Cell C3
Conditional Formatting button.. New Rule.. Use a Formula To Determine Which Cells to Format..
and enter this formula
=AND(ISBLANK(A2),ISBLANK(B2))
 - choose the formula you want to apply.

Use the Format Painter to apply this elsewhere.
0
 
Rory ArchibaldConnect With a Mentor Commented:
=AND(A2="",B2="")
should work.
0
 
route217Author Commented:
Excellent feedback. ..many thanks
0
 
Danny ChildIT ManagerCommented:
of course
"choose the formula you want to apply"
should read
"choose the format you want to apply"...

but thanks for the points anyway!
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.