by Aboo Bolaky
21. July 2009 06:41
Forget the flimsy conditional formulae you had to use in order to filter duplicates in Excel 2000-2003.
Excel 2007 makes it a lot easier.
You just need to highlight the column you want to remove duplicates from, navigate to the Styles Ribbon, then Conditional Formatting -> Highlight Cells Rules -> Duplicate Values. You then only need to choose which color to apply for duplicate cell values..
et voila !!!