VBA Conditional Formating

[dissonance]

Hello,

So I attached an example of what I am wanting.

I have a chart of numbers that I would like to have formatted as either:
(1) Currenty with no decimals and a dollar sign -or-
(2) Percentage with no decimals

I want the range to be formated based on the contents of one cell (B2). If cell B2=1, then I want format (1) above, if B2=2 then I want format 2 above. Unless I am missing something, the normal Format > Conditional Formatting.. options will not change the type of cell format I am wanting.

I am a very green VBA noob so if anyone could help me out with this as simply as possible it would be much appreciated.


EDIT: Also, its my understanding that the sheet won't automatically update using the Forms Drop-Down-Box. I'm not sure how to use the VBA one...

[stanleydgromjr]

dissonance,

Using the "Worksheet_Calculate" Event, see the attached workbook "Worksheet_Calculate Event - dissonance-Example - dissonance - SDG.xls".


Your yellow text:
Format (C33:G37) to:
- Currency with 0 decimals if B2=1
- Percent with 0 decimals if B2=2"

I think, should be Range("C30:G34").


Have a great day,
Stan