-
Select the cells where you want to find duplicate values.
-
On the Home tab, select Conditional Formatting.
-
Select Highlight Cell Rules and choose Duplicate Values.
-
Choose the formatting to apply to the duplicate values in the selected range and select OK.
-
Select the cells where you want to find duplicate values.
-
On the Home tab, select Conditional Formatting.
-
Select Highlight Cell Rules and choose Duplicate Values.
-
Choose the formatting to apply to the duplicate values in the selected range and select OK.