Thread: Count IF function for color/shading of cells
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
[email protected] sblanky@gmail.com is offline
external usenet poster
  
Posts: 1
Default 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?

Reply With QuoteReply With Quote