ddnron
07-17-2010, 08:47 AM
I'm creating a budget for my wife, and have been struggling with finding a code that I need.
When she pays a bill she highlights the dollar amount in light green background.
If the expense is has not been paided it has a white background.
If the expense has clear the bank she highlights it red.
So all outstanding expenses have a cell background color in light green or white.
I would like to attach a button (created already) that she would click and all outstanding expense for the correct date range would be displayed on a "balance" sheet starting in c7. Where the expense name and amount is displayed, listing all outstanding expenses using the next row function.
In cell "a1" I have the "now()" formula.
The dates go to column z.
As an example - if today where July 31, and rent and electric had a white or light green cell color, then it would be copied over to the Balance sheet, with the amount.
rent for Jun30 and gas for Jun 30th would not be copied, red background - they cleared the bank.
Gas for July 28th would not be copied because it has a red background - it cleared the bank.
I would appreciate any help on this. Thanks in advance for your help!
................................................column f..........g..............h
Monthly Planned Debits.................Pay Day......Pay Day.....Pay Day
................................................Jun-30-10....Jul-14-10...Jul-28-10
row 7....rent................................1000...........................100 0
row 8....Electric.............................................300.............. ....
row 9....Gas.................................40...............................4 0
When she pays a bill she highlights the dollar amount in light green background.
If the expense is has not been paided it has a white background.
If the expense has clear the bank she highlights it red.
So all outstanding expenses have a cell background color in light green or white.
I would like to attach a button (created already) that she would click and all outstanding expense for the correct date range would be displayed on a "balance" sheet starting in c7. Where the expense name and amount is displayed, listing all outstanding expenses using the next row function.
In cell "a1" I have the "now()" formula.
The dates go to column z.
As an example - if today where July 31, and rent and electric had a white or light green cell color, then it would be copied over to the Balance sheet, with the amount.
rent for Jun30 and gas for Jun 30th would not be copied, red background - they cleared the bank.
Gas for July 28th would not be copied because it has a red background - it cleared the bank.
I would appreciate any help on this. Thanks in advance for your help!
................................................column f..........g..............h
Monthly Planned Debits.................Pay Day......Pay Day.....Pay Day
................................................Jun-30-10....Jul-14-10...Jul-28-10
row 7....rent................................1000...........................100 0
row 8....Electric.............................................300.............. ....
row 9....Gas.................................40...............................4 0