| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumif or countif based on font color
Hi there,
I would like to sum the number if a range of cells if only the font color is match up. e.g. sum up all value in A1:A15 only when the font is in red color. Currently I am doing it in VBA with a if loop checking against the font property. Just wonder can this be done with a much simpler formulat in worksheet cell? thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I sumif on a font color in excel 2007? | Excel Worksheet Functions | |||
| More Functions based on Font Color | New Users to Excel | |||
| Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
| change font color based on a value | Excel Worksheet Functions | |||
| Sumif and base it on font color of cell | Excel Worksheet Functions | |||
Threaded Mode
