Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

Which formula-based conditional formatting rule highlights an entire row when column E says Overdue?

  1. A =$E2="Overdue"
  2. B =E2="Overdue"
  3. C =E$2="Overdue"
  4. 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.

All Microsoft excel MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as