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 :