Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Conditional Formatting Results
Is it possible to do this?
I would like to have Excel count the cells that are colored when I use Conditional Formatting. Is this possible? For example, I use Conditional formatting to color all of my customers that are from a certain state, then I want to count how many are from that state. Any assistance would be greatly appreciated! Thanks! Jugglertwo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Conditional Formatting Results
http://xldynamic.com/source/xld.Colo....html#counting
"Jugglertwo" wrote: Is it possible to do this? I would like to have Excel count the cells that are colored when I use Conditional Formatting. Is this possible? For example, I use Conditional formatting to color all of my customers that are from a certain state, then I want to count how many are from that state. Any assistance would be greatly appreciated! Thanks! Jugglertwo |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Conditional Formatting Results
How do you know what state they are from? I imagine you have a cell that
contains their state, right? Then all you need to do is count those cells that contain that state: =COUNTIF(B1:B100,"Ohio") -- Biff Microsoft Excel MVP "Jugglertwo" wrote in message ... Is it possible to do this? I would like to have Excel count the cells that are colored when I use Conditional Formatting. Is this possible? For example, I use Conditional formatting to color all of my customers that are from a certain state, then I want to count how many are from that state. Any assistance would be greatly appreciated! Thanks! Jugglertwo |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Conditional Formatting Results
FC
Good site, but note that Bob warns in the "shortcomings" section that you can't count cells colored by Conditional Formatting. One more site to visit is Chip Pearson's http://www.cpearson.com/excel/CFColors.htm Gord Dibben MS Excel MVP On Thu, 31 Jan 2008 19:12:01 -0800, FC wrote: http://xldynamic.com/source/xld.Colo....html#counting "Jugglertwo" wrote: Is it possible to do this? I would like to have Excel count the cells that are colored when I use Conditional Formatting. Is this possible? For example, I use Conditional formatting to color all of my customers that are from a certain state, then I want to count how many are from that state. Any assistance would be greatly appreciated! Thanks! Jugglertwo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting and counting. | Excel Discussion (Misc queries) | |||
CONDITIONAL FORMATTING BASED ON RESULTS IN A CELL | Excel Worksheet Functions | |||
Results of conditional formatting not what desired. How do I corr | Excel Worksheet Functions | |||
Counting Cells with Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional formatting producing inconsistant results? | Excel Discussion (Misc queries) |