Neha is a software professional with 13+ years of experience in the IT Industry. She enjoys writing technical tutorials.
Sometimes you may not want to remove the duplicate values altogether from MS Excel but may want to highlight them anyway. Here's a step-by-step tutorial to highlight duplicate values in Microsoft Excel without deleting them.
How to Highlight Duplicate Values
1. Assume these are the values you have in your Excel sheet and you want to highlight the duplicate values in the list.
MS Excel - Dummy Values
2. Select all values.
MS Excel - Select Values
3. Go to Home menu > Conditional Formatting > Highlight Cells Rules > Duplicate Values…
MS Excel - Highlight duplicate values
4. Click on ‘Duplicate Values…’ a menu will open up.
MS Excel - Highlight duplicate values
5. From the menu drop down list, you can choose to highlight either 'duplicate' or 'unique' values from the list.
MS Excel - Highlight duplicate or unique values
6. You can also choose what kind of formatting you wish to have.
MS Excel - Highlight duplicate values
7. Select the desired options and click on “Ok”.
MS Excel - Highlight duplicate values
8. The final result will look like this.
MS Excel - Duplicate values highlighted
This article is accurate and true to the best of the author’s knowledge. Content is for informational or entertainment purposes only and does not substitute for personal counsel or professional advice in business, financial, legal, or technical matters.
© 2012 Petite Hubpages Fanatic
