Lori... you probably read my posting and are still scratching your head over
what I meant. Well, you can stop scratching now... the problem is I thought
I was answering the posting by ZatHope immediately above yours when I posted
it. I must have clicked the wrong message when I came back to answer it and
you ended up with my words of wisdom instead.<g

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
Pre-format the column as text.

Rick


"Lori" wrote in message
...
So I have a list of emails. I want highlight all those from a given
domain
all those from ".

I tried Cell Value - Equal to - =RIGHT(E:E,16)="widgitmakers.com"

It highlights all the blank emails.

Since an If statement requires a true result, I wouldn't know where to
begin
on that one. Any ideas what's going wrong?

~Lori