Conditional Number Formatting
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,
|