View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lori Lori is offline
external usenet poster
 
Posts: 272
Default Conditional Format Part of Cells Text

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