Hi there,
To assist the lady in accounts, I've been asked (an Excel newb) to create a spreadsheet that allows Accounts to keep track of outstanding invoices our clients are due to pay.
My example:
So far I've made it so that information has to be input into cells A through to E.
30 days are added to the date input to E2, giving the due date in F2.
In G2, =TODAY()-F2 tells Accounts if an invoices is overdue.
If an invoice is marked as not paid in I2, the amount in D2 is red (I used conditional formatting =$I2="NO"). When invoices are paid, Accounts will change I2 to "YES" using a drop down menu and the font returns to black.
What I'm asking for here is that I need a formula for a cell that will Sum the amounts in Column D that are red.
I know from Google searches that I will need to use VB, but because of the Conditional Formatting, the codes don't seem to work as it's not picking up the font colour.
Any ideas?
To assist the lady in accounts, I've been asked (an Excel newb) to create a spreadsheet that allows Accounts to keep track of outstanding invoices our clients are due to pay.
My example:
So far I've made it so that information has to be input into cells A through to E.
30 days are added to the date input to E2, giving the due date in F2.
In G2, =TODAY()-F2 tells Accounts if an invoices is overdue.
If an invoice is marked as not paid in I2, the amount in D2 is red (I used conditional formatting =$I2="NO"). When invoices are paid, Accounts will change I2 to "YES" using a drop down menu and the font returns to black.
What I'm asking for here is that I need a formula for a cell that will Sum the amounts in Column D that are red.
I know from Google searches that I will need to use VB, but because of the Conditional Formatting, the codes don't seem to work as it's not picking up the font colour.
Any ideas?
wow thank you, that's worked perfectly!
