They are red because the font color was changed, no conditions. I didnt
change them, a spreadsheet was sent to me with these numbers already changed.
Because there are more than 26,000 records in this file, I thought I could
write a formula to count the number of red 0's to get a quicker result.

"T. Valko" wrote:

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?