View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TC
 
Posts: n/a
Default conditional formatting for currency

I am trying to figure out a way to formulate or format a column to reflect
particular currencies based on that text located in another column (for
example, if Column A denotes USD or Euro, is there a a formula that will
apply that currency symbol to a value located in Column C or a way to
conditionally format Column C based on what is written in Column A)? I am
using Excel 2003. Thanks.