Hello-

Can't say I'm crystal clear on what you are looking to do, but if it will
help there is a feature called Conditional Formatting in the Format Menu. It
does what you seem to be asking for in part of your post, but how the number
gets converted from an integer to a percent may be another issue.

HTH |:)

"avjunior" wrote:

Sorry, let me add something....
I also would like to have the "y" axis of the graph, changing format
according to the results as well (e.g. %, 0,000, etc).
thanks

"avjunior" escreveu:

Let's suppose I have 2 sheets in a worksheet.
Sheet 1 is a entry form (dropbox for example)
The source of the dropbox are fields of numbers in different formats
(e.g: %; 0,000, etc)
Sheet 2
This is where the numbers are going to after the user selection. So I
would like to have, for example the following results:
result a)
BRANCH TOTAL
A 1,000
B 45,000

result b)
BRANCH PERCENTAGE
A 44%
B 51%

Note that in result a) I need the cells to be formated as 0,000 and result
b) I want the cells formated as %.

So the question is:
How can I have a cell change its number format based on a condition?

thanks