Ok, then it's complicated!

See these:

http://www.cpearson.com/Excel/colors.aspx

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


--
Biff
Microsoft Excel MVP


"force530" wrote in message
...
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?