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.


.