Counting colored cells

[Joebeone]

Is there a way to count cells that are a certain color. Like count how many
cells are blue or how many are red

 

[DS-NTE]

You will find sth here:

http://www.cpearson.com/excel/mainpage.aspx

 

[Peo Sjoblom]

http://www.xldynamic.com/source/xld.ColourCounter.html

--


Regards,


Peo Sjoblom

 

[Chip Pearson]

You need a VBA function to do this. See
http://www.cpearson.com/Excel/colors.aspx for example code.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)