Highlight duplicate values in excel


Highlight duplicate values in excel

we have a lot of data that may be containing the same data in multiple times, we can not view one by one in the data to find out duplicate data.so that excel gives the easy way to find and highlight all duplicate values. its easy step and very user-friendly to use.

Highlight duplicate values in excel

yes there is many method to find duplicate value in excel, but if we need to highligt and mark duplicate value in excel we have a conditional formating in
that give you result with highligt the duplicate value
to highligt duplicate value follow the following procss


1. select all data from which you want to highlight duplicate data
2. on home tab go to conditional formating
Highlight duplicate values in excel

3. go to highlight cell rules.

4. click on duplicate values (always show this option in last)
Highlight duplicate values in excel

5. choose your highlight option and click on ok
Highlight duplicate values in excel

0 Comments