Summing a range depending on cell background colour

I would like to know how to sum a range depending on cell background colour
so if range was background colour red for example it would sum all the red
shaded cells that have numbers in them. Any help appreciated

Take a look at

http://cpearson.com/excel/colors.htm

In article <[email protected]>,
"Re: Inserting an option button in Word"
<[email protected]> wrote:

> I would like to know how to sum a range depending on cell background colour
> so if range was background colour red for example it would sum all the red
> shaded cells that have numbers in them. Any help appreciated

Thanks a lot, brilliant.

"JE McGimpsey" wrote:

> Take a look at
>
> http://cpearson.com/excel/colors.htm
>
> In article <[email protected]>,
> "Re: Inserting an option button in Word"
> <[email protected]> wrote:
>
> > I would like to know how to sum a range depending on cell background colour
> > so if range was background colour red for example it would sum all the red
> > shaded cells that have numbers in them. Any help appreciated
>

At 15:12, an hour before this thread, in your previous post, you said you
had got it working. What's up?

--
HTH

Bob Phillips

"Re: Inserting an option button in Word"
<[email protected]> wrote in message
news:[email protected]...
> I would like to know how to sum a range depending on cell background
colour
> so if range was background colour red for example it would sum all the red
> shaded cells that have numbers in them. Any help appreciated