|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 30th, 2009, 06:30 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Including cells that are highlighted in a formula
I have a strange requirement maybe, but I do a budget spreadsheet on which I
highlight items that have cleared my checking account. I would like to be able to write a formula that sums only the cells that are highlighted a certain color. Is this possible? 
|
|
#2
December 30th, 2009, 06:34 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Including cells that are highlighted in a formula
let me clear this up a little. I don't really mean "highlighted" as in I
highlighted them with a mouse. What I mean is formatted with a fill color. sorry for the confusion. "Robin" wrote: I have a strange requirement maybe, but I do a budget spreadsheet on which I highlight items that have cleared my checking account. I would like to be able to write a formula that sums only the cells that are highlighted a certain color. Is this possible?
|
|
#3
December 30th, 2009, 07:17 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Including cells that are highlighted in a formula
You can't do it with a formula; it'll need VBA:
Colour functions: a.. http://www.cpearson.com/excel/colors.aspx b.. http://xldynamic.com/source/xld.ColourCounter.html c.. http://www.ozgrid.com/VBA/Sum.htm -- David Biddulph Robin wrote: let me clear this up a little. I don't really mean "highlighted" as in I highlighted them with a mouse. What I mean is formatted with a fill color. sorry for the confusion. "Robin" wrote: I have a strange requirement maybe, but I do a budget spreadsheet on which I highlight items that have cleared my checking account. I would like to be able to write a formula that sums only the cells that are highlighted a certain color. Is this possible?
|
|
#4
December 30th, 2009, 09:06 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Including cells that are highlighted in a formula
do I have to have an add-in or something to do VBA in Excel?
"David Biddulph" wrote: You can't do it with a formula; it'll need VBA: Colour functions: a.. http://www.cpearson.com/excel/colors.aspx b.. http://xldynamic.com/source/xld.ColourCounter.html c.. http://www.ozgrid.com/VBA/Sum.htm -- David Biddulph Robin wrote: let me clear this up a little. I don't really mean "highlighted" as in I highlighted them with a mouse. What I mean is formatted with a fill color. sorry for the confusion. "Robin" wrote: I have a strange requirement maybe, but I do a budget spreadsheet on which I highlight items that have cleared my checking account. I would like to be able to write a formula that sums only the cells that are highlighted a certain color. Is this possible? .
|
|
#5
December 30th, 2009, 09:23 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Including cells that are highlighted in a formula
No.
-- David Biddulph Robin wrote: do I have to have an add-in or something to do VBA in Excel? "David Biddulph" wrote: You can't do it with a formula; it'll need VBA: Colour functions: a.. http://www.cpearson.com/excel/colors.aspx b.. http://xldynamic.com/source/xld.ColourCounter.html c.. http://www.ozgrid.com/VBA/Sum.htm -- David Biddulph Robin wrote: let me clear this up a little. I don't really mean "highlighted" as in I highlighted them with a mouse. What I mean is formatted with a fill color. sorry for the confusion. "Robin" wrote: I have a strange requirement maybe, but I do a budget spreadsheet on which I highlight items that have cleared my checking account. I would like to be able to write a formula that sums only the cells that are highlighted a certain color. Is this possible? .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
