How do I count a red number

[force530]

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

 

[John C]

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

 

[force530]

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.

 

[T. Valko]

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.

 

[force530]

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]

Ok, then it's complicated!

See these:

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

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

 

[Peo Sjoblom]

If there are no conditions why do you want to count them?

There must be a reason you want to count them and that reason would be the
condition?

--


Regards,


Peo Sjoblom

 

[force530]

I realized it would be, just figured someone would know.

Thanks ...

 

[Peo Sjoblom]

Nevermind

--


Regards,


Peo Sjoblom

If there are no conditions why do you want to count them?

There must be a reason you want to count them and that reason would be the
condition?

--


Regards,


Peo Sjoblom

 

[Gord Dibben]

If you just want to count the red numbers.........

Select all cells then Edit>Find>Format>Format>Font>Color>Red and OK

Find All.

In the "found" dialog box select top entry then SHIFT + End + Downarrow

On Status bar right-click and select "Count"


Gord Dibben MS Excel MVP

 

[Chip Pearson]

You need VBA code to do that. I have lots of examples, including
summing by color, at http://www.cpearson.com/excel/colors.aspx

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)