See http://www.xldynamic.com/source/xld.ColourCounter.html

--
HTH

Bob Phillips

"Dave H hotmail com" <flameboy4<atdot wrote in message
...
Is it possible to use SUMIF or similar to sum cells where the Fill Color
is
Yellow for instance ??

IE something along the lines of =SUMIF(C3:C15),"FillColor=Yellow",C3:C15)
.....

At present I'm getting along by adding a separate column which has an
asterisk in it and using that as the basis for the SUMIF, but I'd rather
just change the cell colour to select the amounts I'm interested in.

Thanks Dave H.