Can you tally cells by their fill color?
 

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

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

Can you tally cells by their fill color?
 

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

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

On Fri, 25 Jan 2008 13:13:01 -0800, 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

Can you tally cells by their fill color?
 

thanks gord
forgot about that option

regards
FSt1

"Gord Dibben" wrote:

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

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

On Fri, 25 Jan 2008 13:13:01 -0800, 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