Conditional formating - Number

[zapppsr]

Hi.

I have this problem:

I have a table, when sometimes the values in a cell will change and will have different formats:

Eg.: A1 can be % ou can be U$.

I made a conditional formating:
if A2 is "P", then format A1 number as %
if A2 is "U", then format A1 number as U$

When I change some criteria and it matches a condition that A2 is "P", it changes the format of A1 to %, but when it comes to "U" it does not come back to U$.

I think it is a bug, because the first one that matches change, and after that it does not change again...

Any hint or other way to change the number format in a cell according to a criteria?

Thanks in advance!

 

[Jerry Sullivan]

Hi zapppsr,

It appears that if you type "U" directly in Cell A2, the U$ format displays immediately. If "U" becomes the value of Cell A2 as the result of a formula, the U$ format will display after the next calculation.

So it looks like the format change is happening, just not displaying immediately.

That is surprising.