Count Filled colour in cell in given range
 

Hi

I have filled in some cells with different colours, using the fill tool
Red
Blue
Green

I need a formula which will calculate each Red cell in a given range?
I need a formula which will calculate each Blue cell in a given range?
I need a formula which will calculate each Green cell in a given range?

Again the range I need will be two different ranges. E.g A1:B5 and
D1:D5

I look forward to your response

Count Filled colour in cell in given range
 

Hi Sizz,

See xlDynamic at:

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


---
Regards,
Norman


wrote in message
oups.com...
Hi

I have filled in some cells with different colours, using the fill tool
Red
Blue
Green

I need a formula which will calculate each Red cell in a given range?
I need a formula which will calculate each Blue cell in a given range?
I need a formula which will calculate each Green cell in a given range?

Again the range I need will be two different ranges. E.g A1:B5 and
D1:D5

I look forward to your response

Count Filled colour in cell in given range
 

Do we really need to be asked so many times. See response in .excel.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

wrote in message
oups.com...
Hi

I have filled in some cells with different colours, using the fill tool
Red
Blue
Green

I need a formula which will calculate each Red cell in a given range?
I need a formula which will calculate each Blue cell in a given range?
I need a formula which will calculate each Green cell in a given range?

Again the range I need will be two different ranges. E.g A1:B5 and
D1:D5

I look forward to your response

Count Filled colour in cell in given range
 

Sorry

this is the first time asking for help and i didnt know how long it
would take E.g 7-14 days?

But im really impressed with the speed!

I think i posted a question and within 60mins i had a response.

Is this your full time job or do you just browse and help people out??

Count Filled colour in cell in given range
 

No, we are all volunteers here, looking to help, and looking to learn.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

wrote in message
oups.com...
Sorry

this is the first time asking for help and i didnt know how long it
would take E.g 7-14 days?

But im really impressed with the speed!

I think i posted a question and within 60mins i had a response.

Is this your full time job or do you just browse and help people out??