S S. Hughes May 6, 2004 #1 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
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
D Dave Peterson May 6, 2004 #2 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
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
D Dave Hawley May 6, 2004 #3 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 ***
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 ***
