Counting colored cells
 

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

Counting colored cells
 

You will find sth he

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


"Joebeone" skrev i melding
...
Is there a way to count cells that are a certain color. Like count how
many
cells are blue or how many are red

Counting colored cells
 

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

--


Regards,


Peo Sjoblom

"Joebeone" wrote in message
...
Is there a way to count cells that are a certain color. Like count how
many
cells are blue or how many are red

Counting colored cells
 

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)




"Joebeone" wrote in message
...
Is there a way to count cells that are a certain color. Like count how
many
cells are blue or how many are red