Home Excel Content

How to Highlight Duplicate Cells in Excel

Tips 2022-05-24 15:05:21 Excel 97

Step 1

Open an Excel spreadsheet. Highlight the range of cells you want to search for duplicates. To highlight data, left-click at the top left of the first cell and drag the cursor to the bottom right of the last cell.

Step 2

Click on the "Home" tab.

Step 3

Click on "Conditional Formatting" in the "Styles" group.

Step 4

Mouse over "Highlight Cells Rules" and then click on "Duplicate Values."

Step 5

Click on the drop-down menu on the right to choose a highlight color, then click the "OK" button. Excel will highlight the duplicates in the cells you selected.

How to Highlight Duplicate Cells in Excel1