Check for duplicate entries using Conditional Formatting
Click here for example file:
Check For Duplicates Using Conditional Formatting
From the menu:
Format > Conditional Formatting
Fill in the box as follows:
Last updated: 05-Jun-2005 19:19
