highlight duplicate cells in excel
Let’s highlight duplicate cell values from the following cells.
Step 1 : (Select all cells and click condition formatting)
Step 2 : (Select Highlight Cell Rules > Duplicate Values)
Step 3 : (Select any highlight rule)
Output :