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

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

Conditional Format Part of Cells Text
 

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

Conditional Format Part of Cells Text
 

=RIGHT(E:E,16)="widgitmakers.com" is presumably evaluating to FALSE, so with
"Cell Value is" your blank cells will be regarded as meeting that criterion.

Don't use "Cell value is", but use "Formula is" instead
=RIGHT(E1,16)="widgitmakers.com"
--
David Biddulph

"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

Conditional Format Part of Cells Text
 

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

Conditional Format Part of Cells Text
 

Well bless your little pea-picking heart!

It worked, thanks.

"T. Valko" wrote:

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

Conditional Format Part of Cells Text
 

David~

Thanks, that provides a even more insight into what I was doing wrong.

~Lori

"David Biddulph" wrote:

=RIGHT(E:E,16)="widgitmakers.com" is presumably evaluating to FALSE, so with
"Cell Value is" your blank cells will be regarded as meeting that criterion.

Don't use "Cell value is", but use "Formula is" instead
=RIGHT(E1,16)="widgitmakers.com"
--
David Biddulph

"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

Conditional Format Part of Cells Text
 

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

Conditional Format Part of Cells Text
 

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

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

Conditional Format Part of Cells Text
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Lori" wrote in message
...
Well bless your little pea-picking heart!

It worked, thanks.

"T. Valko" wrote:

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