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