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.


1 Answer 1

  • 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? Commented Feb 13, 2019 at 15:30
  • Okay, Thanks. I'll give it a try. Thanks again for the prompt response. Commented Feb 13, 2019 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. Commented Feb 13, 2019 at 16:03
  • @user2888382 try: =IF(AND(LEN($A3), COUNTBLANK($B3:$Z3)>0), 1) i.sstatic.net/ibMg3.png
    – user0
    Commented Feb 13, 2019 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! Commented Feb 13, 2019 at 21:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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