0
If ( cell A10 =2 ) AND ( cells C10:c15 through d10:d15 are blank)

Then color cells c10:15 through d10:15 red

I can do one or the other but can't figure out how to make it meet both criteria prior to coloring it red

1 Answer 1

0

Try creating this new conditional formatting rule with use formula to determine which cells to format using the formula below which is only true if A10=2 and C10:C15 and D10:D15 are blank:

=AND(A10=2,COUNTBLANK(C10:C15)=6,COUNTBLANK(D10:D15)=6)

enter image description here

1
  • Yes, that should work also, thanks! I was being overly cautious. Sep 28, 2012 at 13:19

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .