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.

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.

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.


.

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.


.