Which option is used in Excel to highlight duplicate values?

In Excel, Conditional Formatting is a powerful tool that allows users to apply specific formatting to cells that meet certain criteria, such as highlighting duplicate values. When you utilize Conditional Formatting to manage duplicates, you can set up a rule that identifies cells with the same data and applies a distinct format, such as a different background color or font style, to draw attention to those duplicates.

This feature is particularly useful in data analysis, as it helps users quickly visualize and manage repetitive entries, ensuring better data integrity and easier identification of data trends. While Cell Styles allow for predefined formatting options, Data Validation is focused on data entry rules, and Data Bars are used to provide a visual representation of the data value rather than identifying duplicates. Therefore, Conditional Formatting is the ideal choice for highlighting duplicate values in Excel.