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..