Change currency formatting on value of a cell
Closed
17ND
-
Jan 6, 2010 at 01:58 PM
RWomanizer
RWomanizer
- Posts
- 365
- Registration date
- Monday February 7, 2011
- Status
- Contributor
- Last seen
- September 30, 2013
Related:
- Change currency formatting on value of a cell
- Why can't i change the format of a cell in excel ✓ - Forum - Excel
- How to change date format in excel cell - Guide
- How to change time format in whatsapp - Guide
- Unable to change date format in excel ✓ - Forum - Excel
- How to change date format in openoffice - Guide
2 replies
RWomanizer
Apr 7, 2011 at 05:04 AM
- Posts
- 365
- Registration date
- Monday February 7, 2011
- Status
- Contributor
- Last seen
- September 30, 2013
Apr 7, 2011 at 05:04 AM
Hi 17ND,
suppose your coutries in coulmn B and number in cell D then use conditional formating as
in Formula use =$B1="UK" in format select curreny £ and in applies to give range to column D,
and add new rule as
in Formula use =$B1="DE" in format select curreny € and in applies to give range to column D and so on.
Hi thumic,
remove one $ from your formula
=$A$1="SEK"
write it as
=$A1="SEK",
Regards,
Rahul
suppose your coutries in coulmn B and number in cell D then use conditional formating as
in Formula use =$B1="UK" in format select curreny £ and in applies to give range to column D,
and add new rule as
in Formula use =$B1="DE" in format select curreny € and in applies to give range to column D and so on.
Hi thumic,
remove one $ from your formula
=$A$1="SEK"
write it as
=$A1="SEK",
Regards,
Rahul
Maybe we can work together on this... I'm in the same situation as you are. I've created a list of currencies using "Name Manger" and put them as a drop down selection in A1. Below that I got different values to be entered or auto calculated. I now want these values to "adopt" the currency chosen from the drop down above. I've used "Conditional Formatting" - "Manage Rules" and added, for each currency, the following rule /=$A$1="SEK"/ (without the / ) then in format I've set the currency to "SEK" without commas - hit OK. Click new rule and continue /=OR$A$1="Dollar"/ then in format I've set the currency to "$US" without commas and so ... for each currency I've got in there, I've created a rule in conditional formatting. Once you're done with all of them hit Apply. It works abosultely great when changing 1,2 times but if you change more often, it gets stuck on (in my case) the last currency in the list used in drop down, and when you select one that was earlier on the list it won't change back automatically. I've tried "Data" - "Refresh All" no luck... I've tried checking and unchecking "Stop if true" in the conditional formatting window for one, some and all of the rules - no luck.... Maybe my little workaround helps you in getting to a working solution and by that we've helped each other out... Best regards and good luck, Michael