How to Highlight Duplicate Entries in an Excel Spreadsheet using Conditional Formatting

If you have a large spreadsheet with multiple data records it can help to be able to identify duplicate entries.  This tutorial aims to show you how to use Conditional formatting within Microsoft Excel 2003 or 2007 to show how duplicate records within a coloumn can be highlighted.

[Read more…]