hiding values that havent been used yet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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...
Click to expand...

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)
 
Back
Top