In todays post we will be highlighting cells with duplicate values, to do this carry out the following steps:
- Start by highlighting the range of cells where duplicates may exist.
- Within the ‘Home‘ tab click on ‘Conditional Formatting‘ button, within the dropdown click ‘Highlight Cells Rules‘ and in the next sub menu click ‘Duplicate Values…‘
- A pop up window will appear click ‘OK’
This will highlight all duplicate cell values within the spreadsheet with a light red fill and dark red text.