What does the Highlight Duplicate Values conditional formatting rule do when you apply it to a range?
A) It highlights duplicate values in the range.
B) It deletes duplicate values from the range.
C) It converts duplicate values so they are unique.
D) It moves the duplicate values to another area of the worksheet.

Question

Quizplus · Accepted Answer

The Highlight Duplicate Values conditional formatting rule will scan the selected range and identify any cells with duplicates. These duplicate values will be formatted with a specific color, making them easy to identify and distinguish from other values in the range.

What Does the Highlight Duplicate Values Conditional Formatting Rule Do