Find cell color index

[Danny]

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]

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

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


Regards,

Peo Sjoblom

 

[Danny]

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]

You're welcome, have a great weekend too.

regards,

Peo Sjoblom