View Single Post
  #3  
Old March 12th, 2010, 02:49 PM posted to microsoft.public.excel.worksheet.functions
Gareth_Evans (InterCall EMEA)[_2_]
external usenet poster
 
Posts: 18
Default Highlight Cell that contains invalid email format

Thanks Bob, this is my first experience with RegEx and I'm afraid I'm failing
miserably. I've tried using your code but the cells that are highlighting
confuse me.

When I run the code it highlights cells which contain information but it's
different everytime, I can't see any correlation with the results.

Column L, Rows 1:13



d
..
c
d

@
..
...
..
..
..

The first three cells highlight but the second instances of "D" or
" don't highlight nor do any other cells, just the first
three.

I may not have explained my original request clearly, sorry if I didn't, but
I wanted to highlight cells in column L which aren't in a basic email format
(ie:
etc).
So cells without the @ sign and without at least one dot would be the very
least I'd like to highlight (I know email format's can vary wildly).

Best regards,

Gareth