Formatting with a Formula

[Mike Hogan]

Is there any way to control the format of a cell using a formula?
Here's the scenario:
I have a column of calculated values that can be either a percentage
or a dollar amount depending on the selection of Control Buttons.
I would like the format of the cells to be either Currency or Percentage,
controlled by the same buttons.

I have been unable to find any way to do this. Can it be done? I'm not
too proficient with macros so if that's the only way I'd appreciate an
example to get me started. Thanks for any help available.

Mike Hogan

 

[JE McGimpsey]

Assuming you link your button (I'd recommend a Forms toolbar checkbox)
to a cell (say J1):

=IF(J1=TRUE, TEXT(A1,"$0.00"),TEXT(A1,"0%"))