Chip's colorindex function is to be copied to a general module in the workbook.

Is that where you have it?


Gord Dibben MS Excel MVP

On Tue, 10 Oct 2006 04:53:01 -0700, taxmom
wrote:

I need a little more help.

I wanted to find out the color index of the colors I am using. In column B
I put the formula =colorindex(a2) the results was #name?

What did I do wrong?



"willwonka" wrote:

You can create a custom function using Chuck Pearson's website:

http://www.cpearson.com/excel/colors.htm

Or

I believe the new ASAP Utilities has a function for this.

http://www.asap-utilities.com/


taxmom wrote:
What formula can I use to sum at the bottom of the pages specific colors?

ex.

5.00 yellow
2.00 green
1.00 yellow
1.00 red
3.00 green

total green 5.00
Total Yellow 6.00
Total Red 1.00

Is this possible?

Thank you ! You are all so helpful.