Excel - Data Validation error checking & other useful tips

In my blog Using Data Validation to Control Data Entry we looked at how to set up DATA VALIDATION rules, add prompts and customise alert messages. Now, let's look at a few other features you might want to use when working with VALIDATION rules:

• Finding cells that have DATA VALIDATION rules applied.
• Checking for data that no longer meets your rules.
• Preventing duplicate entries.