Search for string in a cell, then hilight the row
 

That's what I'm trying to do.

At this moment, I haven't found anything that really accomplishes this task
the way I'm attempting to have it work.

The string is this:
<userlevel1</userlevel1 OR
<userlevel163800</userlevel

So, I'm experiecing problems attempting to find that text in the cell--I've
already nailed down the hilighting portion.

Any ideas/suggestions?

Thanks

Search for string in a cell, then hilight the row
 

Chris ,
Could you be more specific pls , and explain in more words what you have and
what you need.
I cannot get a clear view on this.

Is <userlevel</userlevel Or <userlevel163800</userlevel the value in
the cell ?
Do you use VBA to ccomplish this ?


"Chris C" wrote in message
...
That's what I'm trying to do.

At this moment, I haven't found anything that really accomplishes this
task
the way I'm attempting to have it work.

The string is this:
<userlevel1</userlevel1 OR
<userlevel163800</userlevel

So, I'm experiecing problems attempting to find that text in the
cell--I've
already nailed down the hilighting portion.

Any ideas/suggestions?

Thanks

Search for string in a cell, then hilight the row
 

My apologies.

Basically, I have the code written to hilight the row, nothing needed that.
The cell can contain the following things:
<userlevel163800</userlevel1
<userlevel1<userlevel1
<userlevel263801</userlevel2
<userlevel2<userlevel2
<userlevel363802</userlevel3
<userlevel3<userlevel3

So, I need to check for two things [for all three combinations]:
1) That the user level tag exists or not
2) If the tag has any value.

The tag will sometimes be there with a value, sometimes without, sometimes
not there at all. It's not 100% consistent in the data. The data isn't VBA
generated--it comes from an excel import of a text file.

Does that clear everything up?

"MarMo" wrote:

Chris ,
Could you be more specific pls , and explain in more words what you have and
what you need.
I cannot get a clear view on this.

Is <userlevel</userlevel Or <userlevel163800</userlevel the value in
the cell ?
Do you use VBA to ccomplish this ?


"Chris C" wrote in message
...
That's what I'm trying to do.

At this moment, I haven't found anything that really accomplishes this
task
the way I'm attempting to have it work.

The string is this:
<userlevel1</userlevel1 OR
<userlevel163800</userlevel

So, I'm experiecing problems attempting to find that text in the
cell--I've
already nailed down the hilighting portion.

Any ideas/suggestions?

Thanks

Search for string in a cell, then hilight the row
 

Chris ,
Yes , thiscould help a lot.
Unfortunally i'll be going home now , but i'll try to post asap tomorrow (
if not already this evening from home)

Could you tell me what needs to be done in both cases or when all 3
combinations have been checked
for instance : tag is found = rowcolor is red
tag is not found = rowcolor is yellow
tag without value = rowcolor is blue



"Chris C" wrote in message
...
My apologies.

Basically, I have the code written to hilight the row, nothing needed
that.
The cell can contain the following things:
<userlevel163800</userlevel1
<userlevel1<userlevel1
<userlevel263801</userlevel2
<userlevel2<userlevel2
<userlevel363802</userlevel3
<userlevel3<userlevel3

So, I need to check for two things [for all three combinations]:
1) That the user level tag exists or not
2) If the tag has any value.

The tag will sometimes be there with a value, sometimes without, sometimes
not there at all. It's not 100% consistent in the data. The data isn't VBA
generated--it comes from an excel import of a text file.

Does that clear everything up?

"MarMo" wrote:

Chris ,
Could you be more specific pls , and explain in more words what you have
and
what you need.
I cannot get a clear view on this.

Is <userlevel</userlevel Or <userlevel163800</userlevel the value
in
the cell ?
Do you use VBA to ccomplish this ?


"Chris C" wrote in message
...
That's what I'm trying to do.

At this moment, I haven't found anything that really accomplishes this
task
the way I'm attempting to have it work.

The string is this:
<userlevel1</userlevel1 OR
<userlevel163800</userlevel

So, I'm experiecing problems attempting to find that text in the
cell--I've
already nailed down the hilighting portion.

Any ideas/suggestions?

Thanks

Search for string in a cell, then hilight the row
 

I guess things can change color based on the combinations of levels. However,
it gets tricky because of situations such as the following example:

having:
<userlevel163800</userlevel1
<userlevel263801</userlevel2
<userlevel363802</userlevel3

means the same thing as having just this:
<userlevel363802</userlevel3

These are the rules
1. If it's just userlevel 1, then the level is 1
2. If it's userlevel 1 and 2, or just 2, then the level is 2
3. If it's userlevel 1 and 2 and 3, or just 3, then the level is 3

We don't have to do anything when none of them are there.

thanks,
chris

"MarMo" wrote:

Chris ,
Yes , thiscould help a lot.
Unfortunally i'll be going home now , but i'll try to post asap tomorrow (
if not already this evening from home)

Could you tell me what needs to be done in both cases or when all 3
combinations have been checked
for instance : tag is found = rowcolor is red
tag is not found = rowcolor is yellow
tag without value = rowcolor is blue



"Chris C" wrote in message
...
My apologies.

Basically, I have the code written to hilight the row, nothing needed
that.
The cell can contain the following things:
<userlevel163800</userlevel1
<userlevel1<userlevel1
<userlevel263801</userlevel2
<userlevel2<userlevel2
<userlevel363802</userlevel3
<userlevel3<userlevel3

So, I need to check for two things [for all three combinations]:
1) That the user level tag exists or not
2) If the tag has any value.

The tag will sometimes be there with a value, sometimes without, sometimes
not there at all. It's not 100% consistent in the data. The data isn't VBA
generated--it comes from an excel import of a text file.

Does that clear everything up?

"MarMo" wrote:

Chris ,
Could you be more specific pls , and explain in more words what you have
and
what you need.
I cannot get a clear view on this.

Is <userlevel</userlevel Or <userlevel163800</userlevel the value
in
the cell ?
Do you use VBA to ccomplish this ?


"Chris C" wrote in message
...
That's what I'm trying to do.

At this moment, I haven't found anything that really accomplishes this
task
the way I'm attempting to have it work.

The string is this:
<userlevel1</userlevel1 OR
<userlevel163800</userlevel

So, I'm experiecing problems attempting to find that text in the
cell--I've
already nailed down the hilighting portion.

Any ideas/suggestions?

Thanks

Search for string in a cell, then hilight the row
 

Chris ,
pls correct me if i'm wrong
So this i how i see it :
if 1 cell contains the following string :
<userlevel163800</userlevel1<userlevel263801</userlevel2<userlevel363802</userlevel3
(do the "userlevel" strings are within < and ? )

you'll need to figure out what is the highest userlevel within this string
to take action .
Is this correct ?

I'll try to help if I can.
I'm not a super-expert like Bob Phillips , Tom Ogilvy or others like them ,
but i'd like to give it a try.
And maybe others are interested in helping you.
Mario

"Chris C" wrote in message
...
I guess things can change color based on the combinations of levels.
However,
it gets tricky because of situations such as the following example:

having:
<userlevel163800</userlevel1
<userlevel263801</userlevel2
<userlevel363802</userlevel3

means the same thing as having just this:
<userlevel363802</userlevel3

These are the rules
1. If it's just userlevel 1, then the level is 1
2. If it's userlevel 1 and 2, or just 2, then the level is 2
3. If it's userlevel 1 and 2 and 3, or just 3, then the level is 3

We don't have to do anything when none of them are there.

thanks,
chris

"MarMo" wrote:

Chris ,
Yes , thiscould help a lot.
Unfortunally i'll be going home now , but i'll try to post asap tomorrow
(
if not already this evening from home)

Could you tell me what needs to be done in both cases or when all 3
combinations have been checked
for instance : tag is found = rowcolor is red
tag is not found = rowcolor is yellow
tag without value = rowcolor is blue



"Chris C" wrote in message
...
My apologies.

Basically, I have the code written to hilight the row, nothing needed
that.
The cell can contain the following things:
<userlevel163800</userlevel1
<userlevel1<userlevel1
<userlevel263801</userlevel2
<userlevel2<userlevel2
<userlevel363802</userlevel3
<userlevel3<userlevel3

So, I need to check for two things [for all three combinations]:
1) That the user level tag exists or not
2) If the tag has any value.

The tag will sometimes be there with a value, sometimes without,
sometimes
not there at all. It's not 100% consistent in the data. The data isn't
VBA
generated--it comes from an excel import of a text file.

Does that clear everything up?

"MarMo" wrote:

Chris ,
Could you be more specific pls , and explain in more words what you
have
and
what you need.
I cannot get a clear view on this.

Is <userlevel</userlevel Or <userlevel163800</userlevel the
value
in
the cell ?
Do you use VBA to ccomplish this ?


"Chris C" wrote in message
...
That's what I'm trying to do.

At this moment, I haven't found anything that really accomplishes
this
task
the way I'm attempting to have it work.

The string is this:
<userlevel1</userlevel1 OR
<userlevel163800</userlevel

So, I'm experiecing problems attempting to find that text in the
cell--I've
already nailed down the hilighting portion.

Any ideas/suggestions?

Thanks