software

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 responseHi Sizz,

See response in Programming.---
Regards,
Norman
As before (many times)!

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

gt; wrote in message oups.com...
gt; Hi
gt;
gt; I have filled in some cells with different colours, using the fill tool
gt; Red
gt; Blue
gt; Green
gt;
gt; I need a formula which will calculate each Red cell in a given range?
gt; I need a formula which will calculate each Blue cell in a given range?
gt; I need a formula which will calculate each Green cell in a given range?
gt;
gt; Again the range I need will be two different ranges. E.g A1:B5 and
gt; D15
gt;
gt; I look forward to your response
gt;
Bob Phillips wrote:
gt; As before (many times)!
gt;
I have the same problem. Could you please send me the answer.
Thanks