Conditional currency/accounting formatting by user selection?

I have a financial report spreadsheet that is used by groups in 3 different currency areas - Sterling, Euro, Icelandic Krone.

I would like to have a drop down on the first page where the user selects the currency for their group.

I would then like to be able to apply a "currency" or "accounting" format to various cells on other sheets in the book that will display the correct currency symbol depending on what was selected on the front page.

Preferably without a horribly complex conditional format statement on each cell.

Is there a way to conditionally set the default currency symbol within the workbook only.

I don't want to do it via international settings in windows, especially as the reports are sent to the central treasurer who might be in a different currency region.

You will need Bank Table because €1 (EUR) <> £1 (GBP) <> 1 krona (ISK) . I do not know the symbol of last currency
But you can define DataValidationList with EUR,GBP,ISK like =A1="EUR"
and select all cells where you will need change format then define 3 custom format with appropriate symbol.

_-€* #,##0.00_-;-€* #,##0.00_-;_-€* "-"??_-;_-@_-

_-£* #,##0.00_-;-£* #,##0.00_-;_-£* "-"??_-;_-@_-

_-ISK* #,##0.00_-;-ISK* #,##0.00_-;_-ISK* "-"??_-;_-@_-

is that what you want?