Excel Macro that displays a message when a symbol is missing in a cell : I have created an Excel template for my users to enter data in. 

As a precautinary measure, I'd like my template to display an alert message (for a specific column of cells only) if something has been entered by a user but a symbol is missing.

For example: The column 'Email' will contain a list of email addresses that the user must enter. If the user enters an email address that does NOT contain an '@', I'd like an error message to appear telling the user that the email address has not been entered correctly.

As I am still new to Excel VBA, any help on how to build a macro for this will be highly appreciated.

Thank you.