Q:

How to use currency from other column for formatting in “Accounting” in EXCEL for one column

I have numeric data for revenue in column A, and text data as currency code (e.g.  $) in column B.  The currency in column B is not constant, we are pulling it from database. 
In column C i want a revenue data formatted in "accounting" format with the use of currency in column B. How can I change the format in column C, based on the text value in column B, for that row?

A:

This can be done with a few simple Conditional Formatting rules. Conditional Formatting is a set of rules which you can apply to a number of cells - if those rules result in TRUE, then the special formatting applies (including highlighting, number format, etc.).
Go to the Home Ribbon > Styles > Conditional Formatting > New Rule
Then you can select all of column C for your new rule, defined as follows:
=B1="$"

What this means is, relative to C1, if B1 is "$", the equation will produce TRUE, and the special formatting will apply. Because I used "B1" & not "B$1", C2 will look at B2, C3 will look at B3, and so on.
The formatting rules should be set to format as Accounting, with $ as the currency. Then create additional rules exactly the same, for Euros, etc.
You can save yourself having to make one of the rules, by first setting the formatting to column B to one of the formats - ie: Accounting with "$". Then that will be the default format to apply if no Conditional Formatting results in True.
Then for the actual values in column C, just make C1 = A1, and drag down.

