Can you tally cells by their fill color?

[Angyl]

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

 

[FSt1]

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

 

[Gord Dibben]

If you have Excel 2003(don't know about 2007)

You could try this alternate method which doesn't use VBA or any add-ins but
cannot return a SUM to a cell.

In 2003 you can specify the Format color to look for under
Edit>Find>Options>Format>Format.

Select the color from the Patterns dialog and Find All.

In the found dialog box the first cell will be highlighted.

SHIFT + End + Down Arrow to select all found cells.

The selected cells can then be summed/counted by right-click on Status Bar and
"Sum" or "Count"

Otherwise you would need VBA code.

FSt1 has pointed you to Chip's site.


Gord Dibben MS Excel MVP

 

[FSt1]

thanks gord
forgot about that option

regards
FSt1