Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
color count...
My sub counts the color of cells in the range specified.
I'd like to count the color of cells that are colored with conditional formating. Right now, the entire range is set to no fill or some other color, but upon some entry the conditional formating colors the cell red. I need to count the red cells. Conditionally, I have the cells in range hrdata set to red (normally no fill) and this sub doesn't count them. I need an explaination, please? Sub ColorCount() red = 0 For Each Cell In Sheet2.Range("hrdata") If Cell.Interior.ColorIndex = 3 Then red = red + 1 Else End If Next if red 0 then MsgBox red Else End If End Sub Thanks, Rob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
color count...
Read this article http://xldynamic.com/source/xld.CFConditions.html
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "okrob" wrote in message oups.com... My sub counts the color of cells in the range specified. I'd like to count the color of cells that are colored with conditional formating. Right now, the entire range is set to no fill or some other color, but upon some entry the conditional formating colors the cell red. I need to count the red cells. Conditionally, I have the cells in range hrdata set to red (normally no fill) and this sub doesn't count them. I need an explaination, please? Sub ColorCount() red = 0 For Each Cell In Sheet2.Range("hrdata") If Cell.Interior.ColorIndex = 3 Then red = red + 1 Else End If Next if red 0 then MsgBox red Else End If End Sub Thanks, Rob |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
color count...
yeah, I got some of the same info from Chip Pearson's site. I decided
I was going about this all wrong and just did the test with vb like I did for the conditional format and counted that up. It produced the same results. Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count, Sum, and Filter by Color | Excel Worksheet Functions | |||
Can you count cells by color? | Excel Worksheet Functions | |||
Count cells with the red color | Excel Worksheet Functions | |||
Count cells with the red color | Excel Worksheet Functions | |||
countif color count | Excel Programming |