|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I count cells based on their fill color that was set by conditional format
I have a range of cells that has conditional format applied to fill the cell with yellow for example.
I want to be able to get a count of how many of those cells are filled yellow. The normal "count by color" formulas don't seem to work because of the conditional formatting. I'd like the count to be updated whenever any cell in the workbook is updated. Any help would be appreciated |
#2
|
||||
|
||||
Hi, trueimage. You ask this in the programming forum, so I guess you're looking for a VBA solution. It seems to me you want to write a Worksheet_Change subroutine, one that already knows what range you want to check. Every time you change something on the worksheet that program will run, automatically (because it's named "Worksheet_Change" and because you will have placed it in the code module for that worksheet—I'll show you how, if you don't know already). You'll write the program to look through that range and add up the count of yellow cells, then put that count into the proper place.
How much of that do you already know how to do, and how much of it do you need help with? |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Count Conditional Formatting? | tinfanide | Excel | 2 | 10-18-2013 06:19 AM |
How-TO format cells (FILL) by comparing cells | zanat0s | Excel | 1 | 07-03-2012 04:27 AM |
Conditional color fill based on presence of data | avanderh | Excel | 11 | 07-28-2011 09:10 AM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |