Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Any formula to count number of cells with a specific color pattern
Is there any formula to count the number of cells (and total the numerical
content of those cells) with a specific color pattern? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Any formula to count number of cells with a specific color pattern
Yes see:
http://www.cpearson.com/excel/colors.htm -- Gary''s Student - gsnu200756 "Stu" wrote: Is there any formula to count the number of cells (and total the numerical content of those cells) with a specific color pattern? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Any formula to count number of cells with a specific color pat
This function should give you what you want:
Sub countcolor() Dim rng As Range Dim cnt As Long Set rng = Range("A1:E12") cnt = 0 For Each cell In rng If cell.Interior.ColorIndex = 3 Then cnt = cnt + 1 End If Next MsgBox cnt 'or Range("K2").Value = cnt Range("G1").Value = cnt End Sub Notice, it is set up to count the number of cells that are colored red: cell.Interior.ColorIndex = 3 Look here for other Excel color IDs: http://www.geocities.com/davemcritchie/excel/colors.htm Regards, Ryan--- -- RyGuy "Gary''s Student" wrote: Yes see: http://www.cpearson.com/excel/colors.htm -- Gary''s Student - gsnu200756 "Stu" wrote: Is there any formula to count the number of cells (and total the numerical content of those cells) with a specific color pattern? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to count specific words in a number of cells? | Excel Discussion (Misc queries) | |||
how to count cells with specific format (background color)? | Excel Discussion (Misc queries) | |||
How can I count cells of a specific colour (pattern)? | Excel Worksheet Functions | |||
how to count number of cells in a color ? | Excel Discussion (Misc queries) | |||
how 2 Count number of cells that have specific condition format? | Excel Worksheet Functions |