count coloured cells in a range. Specific colour Red, Green, Blue

[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 reponse in Programming.