| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sum cells based upon color of cell
I have a worksheet with color coded cells and numerical data in each cell.
I'd like to tally the contents of the various colors. Any suggestions? |
|
#2
|
|||
|
|||
|
karls
Excel default functions cannot count or sum by color format. See Chip Pearson's site for VBA code. http://www.cpearson.com/excel/colors.htm If cells are shaded due to Conditional Formatting you could possibly sum by those conditions. Gord Dibben Excel MVP On Tue, 17 May 2005 10:15:00 -0700, "karls" wrote: I have a worksheet with color coded cells and numerical data in each cell. I'd like to tally the contents of the various colors. Any suggestions? |
|
#3
|
|||
|
|||
|
You would need code for that
http://www.cpearson.com/excel/colors.htm Regards, Peo Sjoblom "karls" wrote: I have a worksheet with color coded cells and numerical data in each cell. I'd like to tally the contents of the various colors. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Linear Mode
