Thankfully, you’ve got the option to quickly highlight duplicates in your Excel spreadsheet with conditional formatting.
you’re able to choose from the predefined style formats or create your own custom format.
Keep in mind that any value that occurs multiple times will be highlighted in the same way.
you’re free to use the Conditional Formatting Rules Manager to edit the rules.
ClickConditional Formattingin theHometab and then selectManage Rulesat the bottom of the menu.
Change the scope toThis Worksheetto see all the rules and snag the relevant rule to edit or delete.
In this example spreadsheet, some fictional characters and their attributes are laid out in a table.
Suppose you want to see what attributes Thor and Green Goblin have in common.
you could quickly highlight the duplicates in the two columns to achieve this.
You’ll see the duplicate values in the two columns highlighted with the chosen format.
This ensures that the formula applies to each row in the selected range.
Having a good understanding ofabsolute and relative references in Excelis essential for writing efficient conditional formatting formulas.
Duplicates are usually bad news, as they mean that the integrity of your data is compromised.
Moreover, manually searching through massive spreadsheets to find each duplicate is a tedious task.
