Conditional Formatting for currency selector.

[lemonap618]

Hello,
On the attached, I have a currency selector for USD, EUR, and now I added CHF (Swiss Franc) in cell C2.
The conditional formatting in cells F9:F23 and K9:K23 work great when you select USD or EUR; however, I do not now how to adjust the conditional formatting for the newly added Swiss Franc. When the user selects "CHF" in cell C2 I would like F9:F23 and K9:K23 to show the numerical field and then CHF after (e.g. 200 CHF in cell f9). Any and all help is much appreciated!

[Bob Phillips]

Just use formulas

=$C$2="USD"
=$C$2="Euro"
=$C$2="CHF

and set the respective format colours.

[lemonap618]

thank you!