To highlight values greater than 80 you use:

  1. Data Validation → List
  2. Highlight Cells Rules → Greater Than
  3. Paste Special → Values
  4. Filter → Clear
Answer

B) Highlight Cells Rules → Greater Than

Then choose the format.

Computer Science MCQ · More Lab: MS Excel MCQs · Practise