Counting Conditional Formatting Results

[Jugglertwo]

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

 

[FC]

http://xldynamic.com/source/xld.ColourCounter.html#counting

 

[T. Valko]

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")

 

[Gord Dibben]

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