Search results

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....

Thank you very much. Ideally I would like to keep all the values visible rather than filtering them - is that possible with this approach?

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?

It's a pretty wide spreadsheet as it is, covering 15 months, so that may add to its unwieldiness. Any other options?

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...