is there a way....
 

To have a column locate and color cells/cell entries based
on an input?
For example. Cells a-d have numbers. I input a number in
A1. Then Xecel finds and changes the text color on any it
finds of the same number in that column.
Thanks.

is there a way....
 

Have a look at VBA HELP index for FIND. There is a good example there.

--
Don Guillett
SalesAid Software

"Sean" wrote in message
...
To have a column locate and color cells/cell entries based
on an input?
For example. Cells a-d have numbers. I input a number in
A1. Then Xecel finds and changes the text color on any it
finds of the same number in that column.
Thanks.

is there a way....
 

Thank you.
Was unsure of ng to post in which is why the doubel post.


-----Original Message-----
Have a look at VBA HELP index for FIND. There is a good
example there.

--
Don Guillett
SalesAid Software

"Sean" wrote in message
...
To have a column locate and color cells/cell entries
based
on an input?
For example. Cells a-d have numbers. I input a number in
A1. Then Xecel finds and changes the text color on any
it
finds of the same number in that column.
Thanks.


.

is there a way....
 

One other question. Have been searching help. Instead of
setting number for search is there a way for user input to
base search on?

-----Original Message-----
Have a look at VBA HELP index for FIND. There is a good
example there.

--
Don Guillett
SalesAid Software

"Sean" wrote in message
...
To have a column locate and color cells/cell entries
based
on an input?
For example. Cells a-d have numbers. I input a number in
A1. Then Xecel finds and changes the text color on any
it
finds of the same number in that column.
Thanks.


.