Select the range you want to check for duplicates. This can be a single column/row, multiple columns/rows, or group of highlighted cells.

Click "Conditional Formatting," then "Highlight Cells Rules," and click on "Duplicate Values..." to open a pop up window.

Choose how you would like the duplicated data to be displayed, then click "OK" to close the window.

Click "Light Red Fill with Dark Red Text"

Sometimes you want to find duplicates in Excel without deleting them. This guide explains how to use conditional formatting to highlight duplicate values, allowing users to easily identify and manage duplicates in their workbook.

Want to make guides like this in seconds? Yes, it's really that fast.