Conditional Number Formatting

[espresso]

Hi,

I have a spreadsheet I want to send out to people which gives them the
option of switching between US and Euro pricing.

When they switch pricing, I want to switch the format of the currency from
the dollar symbol to the Euro symbol, etc.

This seems like a simple enough thing to do, yet conditional formatting is a
bit primitive in this regards and I can't seem to find this anywhere. Any
suggestions?

Thanks,