Ooooooh cool - thank you. If I wanted to use blue text rather than bold as the variable, what would I change? Also, this doesn't change on the fly as such, is there any way to refresh all the formulae in the file? Obviously you may have other things to do....
Sooo, I would change the text colour of paid items to blue for example, and then in the formula where and how would I specify that I only want to include 'blue' values?
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...