1

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

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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