Which formula-based conditional formatting rule highlights an entire row when column E says Overdue?
- A =$E2="Overdue"
- B =E2="Overdue"
- C =E$2="Overdue"
- D =$E$2="Overdue"
Answer
=$E2="Overdue"
Locking the column but not the row makes every cell in the row test column E while the rule moves down the range.





