Hi all,

I have a quotation tool where cell C13 can be "GBP", "USD" or "EUR", a
data validation where the user can choose the currency.

I'd like the figures in the spreadsheet to have their currency format
dependant on that cell.

Conditional formatting isn't an option, this only allows basic
formatting, not currency.

I've tried looking at a selection change event in VBA but with my
limited experience it going nowhere.

Any suggestions would be much appreciated!!

Many thanks,
Tony Summers