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.
Best Answer
=COUNTIF($B2:$Z2, "=missing")