📞 01223 214177 ✉️ karen@roem.co.uk
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:
Once again, thanks for the inspiration, Sam!
.