|
How do I count a red number
How do i count a range of cells that have a red character; like a red 0?
|
How do I count a red number
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? |
How do I count a red number
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? |
How do I count a red number
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? |
How do I count a red number
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? |
How do I count a red number
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? |
How do I count a red number
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" 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? |
How do I count a red number
I realized it would be, just figured someone would know.
Thanks ... "T. Valko" wrote: 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? |
How do I count a red number
Nevermind
-- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... 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" 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? |
How do I count a red number
If you just want to count the red numbers.........
Select all cells then EditFindFormatFormatFontColorRed 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 On Tue, 14 Oct 2008 12:28:11 -0700, force530 wrote: I realized it would be, just figured someone would know. Thanks ... "T. Valko" wrote: 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? |
How do I count a red number
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) On Tue, 14 Oct 2008 11:33:00 -0700, John C <johnc@stateofdenial 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. |
| All times are GMT +1. The time now is 05:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com