I need to create a format based on a user condition. Example if the person
choose % on a cell the next cell in the following column should be formated
at % if the person chooses number then the next cell in the following column
should be formated as a whole number.

Any idea how to make this happen?