sum of same format cells

[steve]

Hi
I am new to excel and I know how to sum cells, but how do
you sum cells with the same format, ie those with the
same background pattern in excel 2000.
thanks

 

[Frank Kabel]

Hi
not possible without using macros/VBA. So you'll need a
user defined function for this

 

[Debra Dalgleish]

Chip Pearson has information on working with cell colours:

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

However, if the cell colours represent another piece of information from
the row, e.g. Customer "ABC" has green cells, you could use SUMIF to
calculate the total: =SUMIF(A2:A100,"ABC",B2:B100)