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