You have to test each cell individually.

Assume the range of interest is E1:E10.
Select the range E1:E10 so that cell E1 is the active cell. The active cell
is the one that is not "blueish" in color.
Then, in conditional formatting use the Formula Is option.

Formula Is: =RIGHT(E1,16)="widgitmakers.com"


--
Biff
Microsoft Excel MVP


"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