[smaruzzi]

Costs in my sheet could be in a wide range of different currencies. The ideal
visual outcome would be to associate the appropriate currency symbol to each
cost number. The currency information is dynalically generate in a cell
inside the working sheet. As an example, if Euro is the selected currency,
all costs should look like this: ‚¬123.00, ‚¬435.65 and so on.
Is there a smart way to set a sort of conditional formatting so that - based
on the currency selected at a given time - all financial figures are
represented with the appropriate currency symbol?

Thanks, Stefano