View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default Conditional Format Part of Cells Text

LOL ... well, OK, but keep that between the two of us... my wife can be so
jealous at times.<g

Rick


"Lori" wrote in message
...
Rick~

I won't hold it against you. If that's your story although I know you
just
really wanted to talk w/me. You're such a flirt.

~Lori

"Rick Rothstein (MVP - VB)" wrote:

Lori... you probably read my posting and are still scratching your head
over
what I meant. Well, you can stop scratching now... the problem is I
thought
I was answering the posting by ZatHope immediately above yours when I
posted
it. I must have clicked the wrong message when I came back to answer it
and
you ended up with my words of wisdom instead.<g

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
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