Filter for unique values, remove duplicate values, and conditionally format unique or duplicate values in Excel 2007.