Take a look at

http://cpearson.com/excel/colors.htm

In article ,
" Inserting an option button in Word"
soft.com wrote:

I would like to know how to sum a range depending on cell background colour
so if range was background colour red for example it would sum all the red
shaded cells that have numbers in them. Any help appreciated