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.


.