See one method from Bob Phillips:

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

Hope this helps
Rowan

Richelle wrote:
Just wondering if anyone knows if i can do a formula to add up all green
filled cells in a workbook???