Currency conditional formatting
 

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