Always nice to tell us your problem without giving any information with
which to help.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Woodi2" wrote in message
...
I have wrote several macro's and all of them are changing something in a
formula, I cant say what because it just keeps coming up with value.
The formula in particular is =ColorIndex(A12)
I received an answer yesterday regarding this formula and how to use it,
and
thank you to whoever replied. I can find it again to post a thnk you.