Conditional Formatting hould work - You would need to set different rules for each currency
SO for example , for Euro, you write =$A1="Euro" then format as currency and choose euro then
for USD, you write the rule as $A1 = "USD", then format as currency and choose symbol as the dollar e.t.c
Before doing this ensure you have all the data in column B highlighted