Excel VBA Problem

[sailor_9732]

hi guys,
I need implement a function as follows:
some specific colors is defined with specific meanings.
for example, all blue cells means "earning"
and one cell will sum all blue cells's value.

Is it possible that sum cells by the specific colors?

Regards,
Sailor

 

[Frank Kabel]

Hi Sailor
have a look at
http://www.cpearson.com/excel/colors.htm
and use the function SumByColor describes on this site

HTH
Frank