Summarize by cell format?

[Kathy]

I want to summarize data stored in cells which have a common format color.
Is there a way that excel can easily find the common format and summarize the
data for me?

 

[Peo Sjoblom]

You need VBA

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

 

[Bob Phillips]

Take a look at http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Kathy Webster]

Thank you for the link, looks like a learning project ;o) I will give this a
try when I have a bit of time on my hands.

Thanks!
Kathy

 

[Kathy Webster]

Thank you,
I will give that a try as well... looks like I won't be able to get around
writing code after all.

Thanks for your help,
Kathy

 

[Bob Phillips]

Yes you can, it is all written for you.

--

HTH

RP
(remove nothere from the email address if mailing direct)