Counting entries by color code
 

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.

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.

See http://www.xldynamic.com/source/xld.ColourCounter.html

--
HTH

Bob Phillips

"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.

You've been given some tips on how to proceed, including using VBA macros. But
in the future you'll save yourself a lot of grief if you store data in a
column, such as one with Y or N for paid or not, rather than trying to, in
essence, store data in formatting. Formatting wasn't intended for that
purpose. If you create a column, you can, for example, do SUMIF, AutoFilter,
etc.

On Mon, 19 Sep 2005 12:35:01 -0700, Carmen
wrote:

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.