Find or highlight duplicates

1. Select the cells where you want to find duplicate values.

2. On the Home tab, select  Conditional Formatting.

3. Select   Highlight Cell Rules and choose   Duplicate Values.

4. Choose the formatting to apply to the duplicate values in the selected range and select OK.

To find duplicates across worksheets, see Find duplicates across worksheets.

1. Select the cells where you want to find duplicate values.

2. On the Home tab, select  Conditional Formatting.

3. Select   Highlight Cell Rules and choose   Duplicate Values.

4. Choose the formatting to apply to the duplicate values in the selected range and select OK.

To find duplicates across worksheets, see Find duplicates across worksheets.

1. Select the cells where you want to find duplicate values.

2. On the Home tab, select  Conditional Formatting.

3. Select   Highlight Cell Rules and choose   Duplicate Values.

4. Choose the formatting to apply to the duplicate values in the selected range and select OK.