Finding duplicate values

Hello.
I am facing some problem to identify the duplicate entries in my recruitment database sheet, some times the some candidate details are repeating.

Kindly help me to check the following feilds to verify the database with script.

1) Candidate Name
2) Date of Birth
3) Cellphone Number

If the above field values are repeating in my detabase some alert has to popup, so that I can avoid duplicate entries,

Kindly help me,

Regards
Sagar

Hi,

This doesn't require a macro. The attached workbook shows you how to achieve this with conditional formatting. Column D gives you the formula used in the conditional formatting.

I hope this helps

Duplicate post

http://www.excelforum.com/excel-gene...ml#post3595536

Thanks, I didn't realise