I have a column of cells, some of which have different fill colors. I would like to know if there is a formula to count only the number of cells in that range which are filled with green.
I have a column of cells, some of which have different fill colors. I would like to know if there is a formula to count only the number of cells in that range which are filled with green.
Last edited by Mike K.; 06-13-2011 at 03:08 PM.
Hi Mike..
A little bit of googling and you'd find this custom function over at Ozgrid
http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm
Thanks for the link jj
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks