Changing formatting based on Option Button Selection

[Dokat]

Hi,

I have table that is controlled by 3 option buttons. Each button determines whether the values will be dollars, or numbers.

I am using below conditional formatting but i'd like to make it dynamic based on option button selection.

[>=1000000] $#,##0.0,,"M";[<1000000] $#,##0,"K";General

Is this possible to do?

Thanks

 

[ANKUSHRS1]

Please refer attached file for your solution.