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.