View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Can you tally cells by their fill color?

hi
see this site
http://cpearson.com/excel/colors.htm
count by color, sum by color, other stuff by color.
this pertains to 2003 and back. i have not worked with 2007. i have heard
that the above is built in to 2007. but since i have not worked with 2007, i
may be wrong.

regards
FSt1


"Angyl" wrote:

We've been going through a list and shading certain cells colors based on
responses we get from our clients. Red for not interested, yellow for left a
message, etc.

I know it's possible to tally the TEXT in a cell, but is it likewise
possible to tally like the number of cells in a column that are RED fill?

Thanks