If you have lots of data in an Excel worksheet, you’re likely that information is present in duplicate. To identify them quickly you can use the tool of conditional formatting.
1.Select the cell range that you want to search for duplicates.
2.Click the Conditional Formatting in the heading Style Ribbon Home.
3.Click Rules highlighted cells then double values.
4.Choose the style to apply to duplicate values and click OK.
5.Duplicate values are now highlighted.
If you have any suggestions, leave your comment!