Here is one way.

1. Click FormatConditional Formatting on the menu bar
2. Choose "Formula Is" and paste this in the formula box:

=SEARCH("@",A1,1)0

3. Click "Pattern" and choose whatever color you want

This simply does an unintelligent search of A1 to see if contains the
"@" character. You could also use this in the DataValidation box for
the same effect.

HTH,
JP

On Jan 17, 12:23*pm, Theo wrote:
I want to be sure that the entry into a cell is an email address - is there a
way to ensure that at least one character (any character) is an at sign (@).
Any ideas appreciated!!!!