Can i change the "£" , "$" etc before an amount according to the currency in the column next to it?

[tonywatsonhelp]

Hi Everyone,

I have two columns
in column H i have the curencys
and in column I i have the amounts,

I need the amounts to remain numbers so i guess using either custom formating or conditional formating i'd like to show what currency the amounts are in,
So for example My data starts in H22

USD

GBP

EURO SAR

So if H22 = USD for example I22 is foramted as $10,000.00 ,but if its GBP it shows as £10,000.00

I dont mind how this is done, even vba is fine, but it would be handy to have.
Please help if you can.

Thanks

Tony

 

[Fluff]

You can do that with conditional formatting using a formula like

="H22="USD"

and set the number format to suit.

 

[DanteAmor]

You need a conditional formatting rule for each currency

1. Select range I22:I24
2. On the Ribbon's Home tab, click Conditional Formatting, then click New Rule
3. Click Use a Formula to Determine Which Cells to Format
4. For the formula, enter
   =$H22="USD"
5. Click the Format button.
6. Select Custom. For Type enter:
7. $#,##0;-$#,##0
8. Click OK, click OK
9. Repeat the steps for each currency

varios 30jun2021.xlsm
	H	I
22	USD	$123
23	GBP	£456
24	EURO	€897
Hoja10

 

[tonywatsonhelp]

That is brilliant,
thank you dante, and fluff
Tony

 

[Fluff]

Glad we could help & thanks for the feedback.