Hi,

I am using conditional formatting in a cell to show the currency symbol based on the currency selected. I have uploaded an example of this sheet.

In the ProjectCostBuilder sheet you can select the currency you want, then in the ProjectCosts tabs you can see a breakdown of the costs. I want the values in cells E7:E16 to have the currency symbol in front of the number. This works the first time you select the currency from the ProjectCostBuilder sheet, and sometimes the second or third time, but then it just stops updating and will be stuck on a currency no matter how many times you change the value in the ProjectCostBuilder sheet.

Book1ExcelForum.xlsx

Any ideas how I can resolve this?

Thanks
Jennsy