Example Sheet
- Select the column
- Click on Home -->Conditional Formatting -->Highlight Cells Rules --> Duplicate Values, as given below
- Select the colors as below. Click "OK" to highlight all duplicate value
- Now you can see all the duplicate records highlighted as below.
No comments:
Post a Comment