Conditional Formatting is a powerful feature in Microsoft Excel. I use it regularly while working on spreadsheets jam-packed with data. It allows you to change the appearance of a cell based on its value or another cell's value. You create certain conditions, and when those conditions are met, Excel applies the formatting that you choose.
Here’s a quick trick for how you can use Conditional Formatting to find duplicate values in a list of cells:
- Highlight the column of cells that have the duplicate values
- Click on the Conditional Formatting on the tool bar
- Click Highlight Cells Rules
- Click on Duplicate Values
- In the Duplicate Values box make sure the first drop down box is marked Duplicate
- Then in the second drop down choose the format color and style you want – click ok
Looking for more quick Excel tips?