Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding values in coloured cells
Hi
Is there a way to add numbers in cells of one colour together? i.e. all the numbers in the red cells added together in one place and all the numbers in blue cells in another place? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding values in coloured cells
Hi Lois
Bob Phillips has some code on his site to return the Colorindex of cells, and then examples of how to use this within formulae. http://www.xldynamic.com/source/xld.ColourCounter.html -- Regards Roger Govier "lois" wrote in message ... Hi Is there a way to add numbers in cells of one colour together? i.e. all the numbers in the red cells added together in one place and all the numbers in blue cells in another place? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding values in coloured cells
Lois
If you have Excel 2003(don't know about 2007) You could try this alternate method which doesn't use VBA or any add-ins. In 2003 you can specify the Format color to look for under EditFindOptionsFormatFormat. Select the color from the Patterns dialog and Find All. In the found dialog box the first cell will be highlighted. SHIFT + End + Down Arrow to select all found cells. The selected cells can then be summed by right-click on Status Bar and "Sum". Gord Dibben MS Excel MVP On Mon, 5 Nov 2007 07:29:44 -0800, lois wrote: Hi Is there a way to add numbers in cells of one colour together? i.e. all the numbers in the red cells added together in one place and all the numbers in blue cells in another place? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically adding cells with values | Excel Discussion (Misc queries) | |||
sum coloured cells | Excel Discussion (Misc queries) | |||
Adding data to coloured cells | Excel Discussion (Misc queries) | |||
Coloured Cells | Excel Discussion (Misc queries) | |||
Adding multiple cells, return specific values | Excel Worksheet Functions |