David~

Thanks, that provides a even more insight into what I was doing wrong.

~Lori

"David Biddulph" wrote:

=RIGHT(E:E,16)="widgitmakers.com" is presumably evaluating to FALSE, so with
"Cell Value is" your blank cells will be regarded as meeting that criterion.

Don't use "Cell value is", but use "Formula is" instead
=RIGHT(E1,16)="widgitmakers.com"
--
David Biddulph

"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