Find cell color index

Danny · Oct 3, 2003

I'm trying to find the color index of a cell so I can sum
up the cells.

Let's say, cell A1:

=cellcolorindex(A1,False)

Why does my formula return #NAME?

Help!

Peo Sjoblom · Oct 3, 2003

You would need VBA for that, Chip Pearson has that
on his site

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

Regards,

Peo Sjoblom

Danny · Oct 3, 2003

Thanks for the tip. Have a great weekend!

Danny

-----Original Message-----
You would need VBA for that, Chip Pearson has that
on his site

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

Regards,

Peo Sjoblom

.

Peo Sjoblom · Oct 3, 2003

You're welcome, have a great weekend too.

regards,

Peo Sjoblom