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

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

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

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