i tried what you said and it works fine for me.

Here is what I did
Entered Dollar in A1, Euro in A2
Entered some numbers in B1, B2
Selected Col B
Chose Conditional Formatting
For Condition 1 entered
=A1="Dollar" and chose formatting as Custom|"Dollar" 0.00
For Condition 2 entered
=A1="Euro" and chose formatting as Custom|"Euro" 0.00

Got the appropriate formatting in B1 and B2
Now if I change A1 (or A2) to Dollar or Euro B1 (or B2) changes accordingly.

What are you doing differently?




"Mariliz" wrote:

I hope this makes sense. I just got Excel 2007. I have conditional
formatting that will change the format of a column with a currency value
based on another column's text saying what the currency is. (IE, column A is
currency type, column B is value. Formatting rule for B1 says =A1="dollar"
format should be $1.00, =A1="euro" format should be in euros, etc.)

It works fine, once, when I enter the currency type. But if I try to change
it, it doesn't work anymore. Unless I open the rules again and click ok;
then it works again, and will once more if I change the currency. But it
won't do it more than once. I can't figure out why or what I'm doing wrong.
All my other conditional formats work, no matter how much I change the data.
But this one just won't....