Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add fill color in cells | Excel Discussion (Misc queries) | |||
Fill cells with color based on criteria in two cells | Excel Worksheet Functions | |||
HOW TO FORMATE CELLS TO COUNT CELLS WITH A FILL COLOR? | New Users to Excel | |||
Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel |