On Mon November 7 2005 19:17, John Stile wrote:
> calc question - Is it possible to create an equation that totals all
> cells with a particular colored background?
>
> Problem: I have a spread sheet full of different of bills, one column
> of descriptions and one of amounts. I would like to set the background
> of related item amounts, and use an equation to calculate the sum total.
> If I go back and change the background of another cell, or remove the
> color from one, I don't want to have to recalculate the sum total.
Maybe you could use conditional formatting ?
--
CPH : openoffice.org contributor
Maybe your question has been answered already?
http://user-faq.openoffice.org/#FAQ
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
