Summarize by cell format?
 

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?

You need VBA

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

Regards,

Peo Sjoblom


"Kathy" wrote in message
...
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?

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

--

HTH

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


"Kathy" wrote in message
...
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?

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

"Peo Sjoblom" wrote:

You need VBA

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

Regards,

Peo Sjoblom


"Kathy" wrote in message
...
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?

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" wrote:

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

--

HTH

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


"Kathy" wrote in message
...
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?

Yes you can, it is all written for you.

--

HTH

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


"Kathy Webster" wrote in message
...
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" wrote:

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

--

HTH

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


"Kathy" wrote in message
...
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?