title: Currency formating based on other cell text (EXCEL)
body: <p>I’m looking for a macro in excel that will help me, currency formatting a cell based on the value/text of another cell.
  I.E: Cell B28 is my number (567) that I want to currency formatting. Cell B27 is the currency I want to use, let’s say USD. What I want is that if B27 referencing USD, then B28 number will be converted into $567.</p>