#1
|
|||
|
|||
Counting Color in Cells
Is there a way in excel to count the number of color cells.
Example: How many cells are Red? How many cells are Green? |
#2
|
||||
|
||||
Is the color obtained by conditional formatting? If not you'll need VBA I think. Google around it' a well known problem
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Is there a way in excel to count the number of color cells.
Thank you for your response. The color is not obtained by conditional formatting. It is added to the cells. Try a VBA code to count the color of cells?
|
#4
|
|||
|
|||
The number will be in conditional formatting. There is any ease way to count without VBA code?
|
#5
|
||||
|
||||
Please post a sample sheet, or is it the one in your other post?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#6
|
|||
|
|||
counting color cells
It is the one in the other post.
|
#7
|
||||
|
||||
To count the red cells ( where value is less then the preceding cell ) try
Code:
=SUMPRODUCT(--($A$1:$G$2>$B$1:$H$2))+SUMPRODUCT(--($A$1:$A$2<$B$1:$B$2)) Code:
=SUMPRODUCT(--($A$1:$G$2>$B$1:$H$2))+SUMPRODUCT(--($A$1:$A$2>$B$1:$B$2))
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#8
|
|||
|
|||
counting color cells
Thank you!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Counting cells with multiple complex criteria | TishyMouse | Excel | 12 | 12-06-2012 05:05 AM |
various data needs counting | apples | Excel | 2 | 09-16-2012 04:52 AM |
Counting Colors | g48dd | Excel | 2 | 03-13-2011 09:28 PM |
Need cells to autofill with color | Silver Rain 007 | Excel | 1 | 10-22-2009 08:19 PM |
Counting Weeks | leroytrolley | Excel | 1 | 08-18-2008 11:12 AM |