Excel 2011 for Mac: Conditional currency formatting

[arnaudchevalier]

Hello there,
I am trying to do something that thought would be simple but does not seem that easy

I have a cell (A1) with a list of currency value (USD,EUR,...).
I would like another cell (A2) to have the currency format related to that currency automatically applied based on the value of A1.
So, in practice, if A1 = "USD", then the number in call A2 shall appear as "$ 120" for instance.
Conditional formatting by default does not seem to support this (only font, colors, fill, ... but not cell format).

Is there a simple way to do that (simple meaning without macro) ?

Thanks in advance for your help,
Arnaud

 

[arnaudchevalier]

Hi,

I feel I need to be more specific here.
I found how to do this in another thread using a formula along those lines, and not VBA:
=(IF(F3="USD",TEXT(B1*C1,"$0.00"),IF(F3="EUR",TEXT(B1*C1,"€ 0.00"),IF(F3="GBP",TEXT(B1*C1,"£0.00")))))

It actually woks fine but I have so many cells full of numbers and formulas, that if I have to add that on top, it would be messy.
And I try to avoid VBA as well.

I saw in some threads there was a way to use Conditional Formatting button, but it seems in Excel 2011 for Mac, there is no option for cell format conditions.
Or did I miss anything?