counting cells with color

[S. Hughes]

I have a large spreadsheet of which many cells have been formatted with different colors. How do I create a formula to 'count' the red cells, or any color for that matter.
Thanks

 

[Dave Peterson]

You have to use code.

From Chip Pearson's site:
http://www.cpearson.com/excel/colors.htm

You'll even see a section: Counting Cells With A Specific Color

 

[Dave Hawley]

Hi

I have a more flexible Custom Function here that will count or sum cells
by color

http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***