Counting entries by color code

C

Carmen

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

Paul B

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
 
M

Myrna Larson

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