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?

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?

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?

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?


.

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?


.