I don't think you'll be able to use format|Conditional formatting for this.

But maybe you could use data|validation to provide a list of options for the
formatting.

Then use a worksheet_Change event that applies the formatting you want to the
cell(s) that you want.

If you need help, you should provide the list of formatting options. The range
that should have its formatting changed and the version of excel that you're
using.

jk9533 wrote:

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?

--

Dave Peterson