Carmen, have a look here at Chip's site for a way to do it,

http://www.cpearson.com/excel/colors.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Carmen" wrote in message
...
I have a slew of names I entered into a spreadsheet under a field entitled
"Name", some of which I selected and chose a blue background. The blue
colored boxes define those who paid their yearly membership dues. Since
not
every name is color-coded, how can a get a total of the number of blue
colored ones? Since my list exceeds 400, finding a quick way to total
them,
would really ease my work instead of manually counting them. Thanks.