See if one of these links helps you

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

http://www.cpearson.com/excel/SortByColor.htm



"Mr Harlow" wrote:

I have a long worksheet with randomly highlight cells which I wish to
seperately sum. Is there a way to do this without the tedious job of
selecting them all?