If Excel is telling you that you have an incorrect name, you have presumably
not correctly defined the ColorIndex UDF.

If you are struggling to understand the links I gave you, then I guess
you'll struggle with http://www.ozgrid.com/VBA/Sum.htm too.
As I said, "You can't do this with a formula.". If you can't cope with the
VBA you can't do it.
--
David Biddulph

ant wrote:
The first link I tried but Excel said it was an incorret name. The
second link was way to hard to understand. I need something set out
simply and clearly.

"David Biddulph" wrote:

You can't do this with a formula. It would have to be VBA.
http://xldynamic.com/source/xld.ColourCounter.html
http://www.cpearson.com/excel/colors.aspx
--
David Biddulph