Why are some numbers red? That's what John C meant. They're red for a
reason, right?

You can write a formula based on the logic of *why* the numbers are red.

--
Biff
Microsoft Excel MVP


"force530" wrote in message
...
Just a red 0 for example. Not conditional. I have a list of black and red
0's
in column A2:A100 and I want to count the number of red ones.

"John C" wrote:

What determines if something is red? Is it conditional formatting? You
could
just do a count based on the conditional formatting if it is.
--
John C


"force530" wrote:

How do i count a range of cells that have a red character; like a red
0?