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: 01-Mar-2011 20:50
