adding values in coloured cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Edit>Find>Options>Format>Format.

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
 
Back
Top