Hi Martin
Basically it can't be done by Excel in its normal configuration.
However, have a look at the site below for adding ColourIndex to Excel,
which will then allow you to count cells and other interesting stuff.

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

HTH
Michael Mitchelson


"Martin C" wrote:

Having trouble counting cells in an excel spreadsheet that have a certain
color only. Can anyone help?