Conditional formatting problem

  • Thread starter Thread starter si.lav
  • Start date Start date
S

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
 
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
 
Back
Top