Bob, struggling with suggested solution. Tried pasting in code into sheet and
using sumproduct but Excel won't recognise ColorIndex part of formula. Not
sure what I'm doing wrong. Any help appreciated.

"Bob Phillips" wrote:

You won't do it without programming. See
http://www.xldynamic.com/source/xld.ColourCounter.html for a solution, but
note the constraints.

--
HTH

Bob Phillips

" Inserting an option button in Word"
soft.com wrote in message
...
I would like to be able to sum the numnber of times the cell background is
red in a range. I would also like to do it separately for the background
colour yellow, and separately for the background colour bright green.
Ideally
I would like to do it without programming code but any solution very
welcome.
I am using Excel 2003

Thanks.