Highlight specific name

J

Juran

I have a list of street names

Is there a way that when I enter in a particular cell the
street name (Main St.), all Main street on may list will be
highlighted?

Thank you for your help.

Juran
 
D

Dave Peterson

You could use Format|conditional formatting to highlight all the cells that
contain "main st." (not just highlight the characters "main st." themselves.

If A1 is your cell where you type the name:

Select the range that contains the addresses. (Say B2:B999)

Then with B2 the activecell:
format|conditional formatting
formula is:

=COUNTIF(B2,"*"&$A$1&"*")>0

And give it a nice format.
 
J

Juran

Dave,

Thank you for your help.

I did as your recommended, and on formating I ask to change
the color and put the street name in bold. Bun
unfortunately is not working.

Rubem
 
D

Dave Peterson

What was in one of those cells where you expected it to work?

What was in A1?

What did you use for your conditional formula?
 
G

Guest

On the cells, I have the street name.

Cell A1 is where I will enter the name of the stree I want
(Main St.)

I used formula and =COUNTIF(B2,"*"&$A$1&"*")>0

Then in format I chose the color, so when I type the name
of the street on cell A1, on my list all cells that contain
Main St. would be the color I selected.

Juran
 
N

NewsMan

This solution works,make sure all the cells in the range are selected
(e.g. B2:B) when inputing the conditional format.
 
J

Juran

Dave and Newsman,


The formula asked to use B* and A*,I forgot to adjust to my
needs.

Now it is working.

Thank you.



Juran
 
Top