In Excel 2003 Pro, is there any way of formatting currency in number format
conditionally - and how is it done?
For example, cell A1 can be « $ », « ‚¬ », or « £ ».
If cell A1 is « $ », then the contents of cell B1 should be formatted with a
$ sign whereas if A1 = « ‚¬ », then the contents of cell B1 should be
formatted with the ‚¬ sign and so on.
Thanks for any help