Color rule with a formula
Color the whole row when a column says "Late".
Ready-made rules only look at the cell itself. With a formula rule, you decide any condition, and you can even color the whole row.
Module: Lists and automatic colors. Lesson 51 of 62.