CHANGE CURRENCY

P

Pattyleb

I have a cell (A:1) that is a drop down menu where you can choose different currencies, if for example you choose EUR i want B:2 to have the format of euro currency when you enter your number. Is there a conditonal format for that?
 
Top