Suming cell with colour.

[Peter1973]

I have a row of cells A1:A10 then in A11 I have simple formula
=SUM(A1:A10)

Is there a formula I could use that would detect if one of the cells was fomated to a certain colour ie yellow that would then add 8 to the answer.

So if A1:A10 total was 35 but A8 was formatted yellow the toal would be 43.

 

[Smitty]

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

HTH,

Smitty

 

[Greg Truby]

Also, if you want a listing of what all the colors are, there's one in this wiki entry.

 

[Peter1973]

Thanks for the help my knowledge of vba is small enough to fit on a stamp but im trying to get to grips with the info on the links.

Thanks

 

[Greg Truby]

Obviously the relevant one of Chip's UDF's listed there is SumByColor. This one is a very well-known UDF by now. So if you just do a search here on SumByColor you'll get plenty of threads related to its usage/implementation.