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