Conditional Format Part of Cells Text
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
|