Conditional formatting

[JohnnySmith11]

Hi everyone!
I have a list of email addresses in column A.

A valid address is one that meets all the following conditions:
1. Has the sign "@".
2. At least 2 characters before the sign "@".
3. No spaces.
4. Has at least one dot "."

If the address is valid – it will be shown in blue color.
If the address is not valid – it will be shown in bold red color.

I am so lost. Could anyone please help?

Thanks so much in advance

 

[pjmorris]

I understand... And what simple function would you do just for this rule "At least 2 characters before the sign @" ? How do I make an if that does that?

have you tried the CF function that I gave you in post 6?