Column A contains student names. The other columns show work that is missing or incomplete.

I'd like to be able to have cells in column A colored in if work from various classes is missing, without setting individual conditional assignments for each column (other than A). I don't know how to refer to all the other columns in ONE formula.

  • custom formula is: =COUNTIF($B2:$Z2, "=missing")

  • Thanks so much for the response. However, what if instead of "missing," the cell is blank? How would you modify the formula in that case? – user2888382 Feb 13 '19 at 15:30
  • Okay, Thanks. I'll give it a try. Thanks again for the prompt response. – user2888382 Feb 13 '19 at 16:00
  • Okay, I tried that, but every student's name cell is yellow, even those who don't have missing work. Also, I changed the COUNTBLANK part to $B3:$Z3 because there are two rows of header information for each assignment. – user2888382 Feb 13 '19 at 16:03
  • @user2888382 try: =IF(AND(LEN($A3), COUNTBLANK($B3:$Z3)>0), 1) i.stack.imgur.com/ibMg3.png – user0 Feb 13 '19 at 16:10
  • Thanks again, but it's still turning ALL the names yellow. I really appreciate you trying to help me with this. I wish I knew more about scripts and formulae! – user2888382 Feb 13 '19 at 21:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.