Data Validation to force user to add correct email address

Hello   I have a large spread sheet which includes 100's of emails, often if the email address is unknown someone will write random text which is quite frustrating, I have tried using custom data v...