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? Feb 13 '19 at 15:30
  • Okay, Thanks. I'll give it a try. Thanks again for the prompt response. 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. 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! 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.