Excel Tip Highlight Duplicate Values With Conditional Formatting

****SUBSCRIBE****** to my Excel at Excel newsletter 3 FREE Excel Tips every 15 days http://www.howtoexcelatexcel.com ----------------------------------------­--------------------------- Website http://www.howtoexcelatexcel.excel.com Twitter https://twitter.com/howtoexcelatex Pinterest http://www.pinterest.com/howtoexcelat From Excel 2007 onwards it is really easy to identify duplicate values in an Excel range of cells with just a few clicks and a bit of conditional formatting. Select the range of cells you want to analyse- the quickest way is to hit CTRL+A Home Tab-Conditional Formatting Select Highlight Cell Rules-Duplicate Values The Duplicate Values Dialog Box will appear- just select your type of formatting for your duplicate values Duplicate values will be highlighted If you want to then filter out your duplicate values you can do so from Excel 2007 onwards by just right clicking on one of the coloured duplicate cells, select Filter- Filter by selected cells colour. Your list will be collapsed to just see the duplicated values. Job done!.