bank account
 

Hi all,

just a quick question, I hope!

I have set up a grid to balance my cheque book and it all works but I
have a formatting question

How do I stop the balances (270) from repeating if there is no content
in the cell to the left?

I.e. there is a value for insurance, 40, so I want the new balance, 460
to display but I don't want to display the 270s below beer as there is
no item listed after that, at the moment but there will be when I write
a cheque..

Opening Bal. 1000
mortgage 500 500
Insurance 40 460
food 30 430
car ins 30 400
ISP 10 390
petrol 20 370
bill 50 320
beer 50 270
270
270
270
270
270

Thanks

bank account
 

In the column with your totals, we'll call it column 'J' 'cuz that's the
first letter in my name, and well start in row 13 'cuz that's my
favorite number:

=IF(I13<"",J14-I13,"")

-Pikus


---
Message posted from http://www.ExcelForum.com/

bank account
 

Thanks,

I will go and try it now

what service

thanks again


Pikus Writes
In the column with your totals, we'll call it column 'J' 'cuz that's
the
first letter in my name, and well start in row 13 'cuz that's my
favorite number:

=IF(I13<"",J14-I13,"")

-Pikus


---
Message posted from http://www.ExcelForum.com/

bank account
 

Conditional formatting, formula of (e.g) =A10=A9 and set the font colour to
white

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"nospam" wrote in message
...
Hi all,

just a quick question, I hope!

I have set up a grid to balance my cheque book and it all works but I
have a formatting question

How do I stop the balances (270) from repeating if there is no content
in the cell to the left?

I.e. there is a value for insurance, 40, so I want the new balance, 460
to display but I don't want to display the 270s below beer as there is
no item listed after that, at the moment but there will be when I write
a cheque..

Opening Bal. 1000
mortgage 500 500
Insurance 40 460
food 30 430
car ins 30 400
ISP 10 390
petrol 20 370
bill 50 320
beer 50 270
270
270
270
270
270

Thanks

bank account
 

it's srevice with a smile too! :) HA

--
Message posted from http://www.ExcelForum.com