Count Filled colour in cell in given range

[sizz1]

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
D15

I look forward to your response

 

[Norman Jones]

Hi Sizz,

See xlDynamic at:

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

 

[Bob Phillips]

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)

 

[sizz1]

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??

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)