Conditional Format with more than 3 variables

[cterjesen]

I have a file where I want to change the number format of certain cells based on a value from another sheet. Thus, the user will use a drop down list in a "Menu" worksheet to select "USD", "EUR", "CHF", "AED", etc. for different currency formats. Based on this selection, certain cells in another worksheet will have the number format changed to that currency.

I have too many currency types to fit the conditional formatting option.

Also - can someone point me to the different NumberFormat options in VBA?

thanks!