Conditional Formatting?

[lctrues]

I have three columns of dollar amounts. One is an estimated amount, one is an actual amount that will be debited from the estimated amount, and the final column is a balance amount. I need for the balance amount to reflect a 0 balance once the actual equals the estimated instead of building a credit amount.

Thanks

 

[Mark W.]

And, what is the balance amount when they're not equal?

 

[lctrues]

The balance amount will be the difference between actual and estimated until a zero balance is met...

 

[ThePencilQueen]

How is the actual amount being changed? Is it just someone punching in numbers or does it calculate the value from elsewhere on the spreadsheet?

Do you just want to use the third column to warn people if the actual amount is equal to or exceeds the estimated value?

 

[paliman]

If I understand you correctly, you have to use a formula to calculate your balance.

Say col. A is the estimated amount, col. B the actual amount and col. C your balance.

In C2 enter and copy down:

=SUM($A$1:A1)-SUM($B$1:B1)

And this will give you the balance after each movement

Is this what you want?

 

[lctrues]

The spreadsheet calculates the balance. Now I have been asked to add the additional formatting that will stop the balance once it reaches zero and will show the zero balance in the column. As it is set up now it will continue to calculate a balance each time a new amount is added.

 

[Mark W.]

Provide some sample data (including cell references), and indicate the desired results.
This message was edited by Mark W. on 2002-10-15 12:07

 

[lctrues]

=SUM($F12:$F200)
F 12
F12:F200
=$D12-$E12


D12-no formula
E12-no formula
This message was edited by lctrues on 2002-10-15 12:23

 

[Mark W.]

And, the data? Desired results?

 

[lctrues]

Est. Cost
(Cr, Rpt.#)
(1)$500.00
(
Ck. Req.
(Trial Bal.)
(1st entry)$400.00
(2nd entry)$200.00
Balance
(Est.Liab.)
=$D12-$E12
$`100.00 balance
$this column should then reflect a 0 balance because the actual charges have depleted the estimated amount. They do not want to show anything above and beyond the estimated amount