Weekly Computer Tip # 283
10 September 2009

spot the difference (Excel 2007)

Today's tip (a day early rather than a day late ;) is inspired by Sam from Cambridge who asked whether there was a way to spot duplicates in her Excel worksheet. I showed her the new Excel 2007 Remove Duplicates button (on the Data tab, in the Data Tools group) but she didn't want to get rid of the values. She just wanted to see them, which is why we used Excel 2007's improved conditional formatting functionality instead.

Here's how:

1. Select the range of cells you want to check for duplicate values.
2. On the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click Highlight Cells Rules.
3. Select Duplicate Values.
4. Click OK.

Once again, thanks for the inspiration, Sam!

Until next week.

PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.

Home   Training   Support   Clients   Contact Details   Virtual Press Room   Disclaimer