| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i change cell background colour depending on its content? | Excel Discussion (Misc queries) | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| Background Colour Depending On Input | Excel Discussion (Misc queries) | |||
| Summing a range if a certain background colour | Excel Programming | |||
| Sum depending on cell background color | Excel Programming | |||
Hybrid Mode
