| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of values typed in a specific color
Hi everybody,
I'd like to sum entries in a row. The criteria for being in-/excluded in the summing process is the font color in which the value is typed. I tried the "sumif" function, but don't know how to specify the criteria. The simple approach with typing "font green" or similar unfortunately doesn't work... does anybody know how to do this? Might there be another possibility (cell color, font type?) Thanks in advance for your answers Karin |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of values typed in a specific color
See e.g. http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm
Regards, Stefi €˛Karin€¯ ezt Ć*rta: Hi everybody, I'd like to sum entries in a row. The criteria for being in-/excluded in the summing process is the font color in which the value is typed. I tried the "sumif" function, but don't know how to specify the criteria. The simple approach with typing "font green" or similar unfortunately doesn't work... does anybody know how to do this? Might there be another possibility (cell color, font type?) Thanks in advance for your answers Karin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to set a cell that if it has a date typed then turn color | Excel Worksheet Functions | |||
| How to make it so only specific words can be typed in a cell | Excel Discussion (Misc queries) | |||
| Change Text Box Color When Typed In | Excel Discussion (Misc queries) | |||
| Color of a specific gridline | Charts and Charting in Excel | |||
| how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
Linear Mode
