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

Summing a range depending on cell background colour
 

Take a look at

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

In article ,
" Inserting an option button in Word"
soft.com 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

Summing a range depending on cell background colour
 

Thanks a lot, brilliant.

"JE McGimpsey" wrote:

Take a look at

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

In article ,
" Inserting an option button in Word"
soft.com 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

Summing a range depending on cell background colour
 

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

" Inserting an option button in Word"
soft.com wrote in message
...
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