Conditional formatting problem

[si.lav]

Hi,

I am creating a template which will return values in variou
currency's. In a column at the beginning of the sheet I ask what th
used currency will be. What i want to know is if, based on the valu
entered in the currency column, can i add that currency sign on an
other value then entered on that row?

Is it possible?

Thanks in advance,

Simon

 

[Frank Kabel]

Hi
not really possible with worksheet functions or conditional format.
This would require an event procedure to change the format of your data
entry range