Select Column E and FormatCFFormula is =RIGHT(E1,16)="widgitmakers.com"

Format to a color and OK your way out.


Gord Dibben MS Excel MVP


On Mon, 8 Oct 2007 14:29:01 -0700, Lori wrote:

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