I know this may be stretch, but does anyone know of a way to display
different cell formatting in a conditional? I have a spreadsheet that
reports values in the currency of the local country. Only one country
is shown at a time, so sometimes the values are in Euros and other
times in US Dollars. Is it possible to change the cell formatting to
display the appropriate currency format based on a selection in a
different cell?

Example: If(A1="UK",*use pound symbol*,*otherwise use US dollar sign*)

Thanks for any insight.