matt
Well-known member
- Mar 19, 2007
- 1,563
How can I distinguish between values in a column so that some are treated as paid and some as outstanding.
For example, if the bold values below are paid and the unbold are unpaid (and values are likely to switch from unpaid to paid or vice versa) how can I dynamically calculate the total of the paid and unpaid values?
Item 1 100.00
Item 2 500.00
Item 3 400.00
Item 4 100.00
Item 5 600.00
---------------
Total Unpaid xxxx.xx
Total Paid xxxx.xx
Ideally I would like to be able to easily and visually mark a value as paid or unpaid (cell or text colour maybe). I'm using Excel 2010 (Windows).
Any ideas?
Cheers
For example, if the bold values below are paid and the unbold are unpaid (and values are likely to switch from unpaid to paid or vice versa) how can I dynamically calculate the total of the paid and unpaid values?
Item 1 100.00
Item 2 500.00
Item 3 400.00
Item 4 100.00
Item 5 600.00
---------------
Total Unpaid xxxx.xx
Total Paid xxxx.xx
Ideally I would like to be able to easily and visually mark a value as paid or unpaid (cell or text colour maybe). I'm using Excel 2010 (Windows).
Any ideas?
Cheers