Conditional Formatting in Excel

[Yossy]

I have some columns that I want to format currency based on currency figures
in the column cells. Lets say Cell A2 = 1, B2 = 1.30, cell D2= 1.7

How do I make these figures be conditionally formatted so that cell A2 can
be = USD 1.00, cell B2 = EUR 1.30 and Cell D2 = GBP 1.7 - Where USD = 1.00,
Eur = 1.30, GBP = 1.7. I use Excel 2007.

All help totally appreciated. Thanks

 

[Sheeloo]

If you have the correct values in the cell then simply use Custom Format
in Col A use "USD" #,##0.00
in Col B use "EUR" #,##0.00
in Col D use "GBP" #,##0.00

If you have the base amount in USD in Col A
then use in B2
=A2*$M$1 assuming M1 has the conversion rate for USD to EUR
=A2*$M$2 assuming M2 has the conversion rate for USD to GBP
and format the columns as above

and so on