Count IF function for color/shading of cells
 

How do you count the number of cells with a fill color of green in a range of
cells?

Count IF function for color/shading of cells
 

You would have to create some VBA code. See here for an explanation:
http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

Dave
--
Brevity is the soul of wit.


"Rick" wrote:

How do you count the number of cells with a fill color of green in a range of
cells?

Count IF function for color/shading of cells
 

Rick

Excel prior to 2007 version cannot count by color.

See Chip Pearson's site for Code.

http://www.cpearson.com/excel/colors.htm


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 11:45:01 -0800, Rick wrote:

How do you count the number of cells with a fill color of green in a range of
cells?

Count IF function for color/shading of cells
 

Thank You. It works great !

"Dave F" wrote:

You would have to create some VBA code. See here for an explanation:
http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

Dave
--
Brevity is the soul of wit.


"Rick" wrote:

How do you count the number of cells with a fill color of green in a range of
cells?

Count IF function for color/shading of cells
 

Ok, I've been looking all over for this. I DO have excel 2007. And I've
seen lots of articles saying that it can do count by color. But I
haven't found anywhere explaining how to do that if you have excel
2007. And obvioiusly, excel help isn't helping...

Can someone give me the function name to lookup?


Gord Dibben wrote:
Rick

Excel prior to 2007 version cannot count by color.

See Chip Pearson's site for Code.

http://www.cpearson.com/excel/colors.htm


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 11:45:01 -0800, Rick wrote:

How do you count the number of cells with a fill color of green in a range of
cells?