Macro to show message on invalid format by checking if filled for dynamic range

[coolguyvarun01]

Hi Experts,


I was given a task wherein I have to write a macro on email to check if the format is anything@anything.anything
for a complete column when value is entered in that cell ,blanks are allowed. now data can be in rows 1,2,3,7,9....
Kindly help.

Operation	name	email
Create	ABC	abc
Create	BCD	ab@c.com
change	sfdsf	abc@y.com

<tbody>
</tbody>

p.s.: already data validation is there to check if user is entering value before choosing the operation