Pappey,

You can sum a range by color by using a VBA function. This site provides
the code:

http://www.erlandsendata.no/english/...saddsumbycolor

----
Regards,
John Mansfield
http://www.pdbook.com

"Pappey" wrote:

Can the criteria be set using cell formatting information; as an example I'd
like to add all value of all cells with red background color.