| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Using IF function for many many cells, and using more than one IF function | Excel Worksheet Functions | |||
| HOW DO I COUNT CELLS WITH DATA BY COLUMN? | Excel Worksheet Functions | |||
| function to count the amount of cells depending on part of the cell entry | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Linear Mode
