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.