hiding values that havent been used yet
 

I want to keep a running total of a balance column, so I have a formula
adding the profit and loss of the day, and adding it to the previous days
total. It works, but it starts by filling the whole column with noughts to
the bottom of the page. As I add values, it repeats the latest value all the
way down the page. I want to keep the cells empty until a new amount is added.

I would also like to display negative values in red.

Thanks for help...

Assuming your values are in column A, put this in B1 and copy down, then
format column B...........FormatCells CUSTOM and choose one of the
[RED] formats.

=IF(A1<0,SUM($A$1:A1),"")

Vaya con Dios,
Chuck, CABGx3


"charliefortune" wrote in message
...
I want to keep a running total of a balance column, so I have a formula
adding the profit and loss of the day, and adding it to the previous days
total. It works, but it starts by filling the whole column with noughts
to
the bottom of the page. As I add values, it repeats the latest value all
the
way down the page. I want to keep the cells empty until a new amount is
added.

I would also like to display negative values in red.

Thanks for help...

"charliefortune" wrote in message
...
I want to keep a running total of a balance column, so I have a formula
adding the profit and loss of the day, and adding it to the previous days
total. It works, but it starts by filling the whole column with noughts
to
the bottom of the page. As I add values, it repeats the latest value all
the
way down the page. I want to keep the cells empty until a new amount is
added.

I would also like to display negative values in red.

Thanks for help...

One way to achieve this would be to have a hidden column which holds the
results and copy the value to the visible part of the worksheet.
For example, col C shows profit of loss value, col Z shows the running total
then column D would have the formula =IF(C2="","",Z2)