Hi Everyone,

I'd like to create a macro that validates if emails are properly entered in column A (minus the column heading) once the emails have already been entered. There should only be one email per cell, the email should be in proper format (which includes no spaces and unwanted characters), and all the cells with a mistake in them should be highlighted in orange and give one error message for all. Preferably I'd like this macro to be activated by a button in the active sheet.

Thank you for your time and I'll appreciate all the help I can get.

Regards,
DrNo1