Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top
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

share|improve this question

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

share|improve this answer
    
Yes, that should work also, thanks! I was being overly cautious. – HeatfanJohn Sep 28 '12 at 13:19

You must log in to answer this question.

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