software

I'm ashamed to say that although I passed City amp; Guilds a few years ago
I've forgotten almost everything I know about this program.

if I have a column of numbers say cells A1- 500, how can I put the
running total in B1, B2, etc?

Also, when there is a negative balance this comes up red, can I change
this to black?

ThanksIn B1 put

=SUM($A$1:A1)

copy down

Use a format of

£#,##0.00

will return negative with a preceding minus--

Regards,

Peo Sjoblom

quot;thedarkmanquot; gt; wrote in message ups.com...
gt; I'm ashamed to say that although I passed City amp; Guilds a few years ago
gt; I've forgotten almost everything I know about this program.
gt;
gt; if I have a column of numbers say cells A1- 500, how can I put the
gt; running total in B1, B2, etc?
gt;
gt; Also, when there is a negative balance this comes up red, can I change
gt; this to black?
gt;
gt; Thanks
gt;