Conditional number formatting can be done in several ways, but this question is about the ”right click → format cells” way, manually entering the number format.
This is an example that didn't work like I expected: [BLUE][<-5]Standard;[RED][>30]Standard;[GREEN]Standard For values <-5 it looks right, for example -6 is displayed as -6 in blue. However values≥-5 and <0 display a POSITIVE value in green. Where is the minus sign? And if there isn't supposed to be one, why is it there in the blue case? Adding a minus sign in the format code doesn't help much, since I don't want a minus sign for positive values: [BLUE][<-5]Standard;[RED][>30]Standard;[GREEN]-Standard In this case, green values will always display with a minus sign, which isn't good since all value≥0 and ≤30 are positive… Is this a bug or am I doing something wrong? I also tried the following: [BLUE][<-5]Standard;[GREEN][<=30]Standard;[RED]Standard It turns out exactly the same as [BLUE][<-5]Standard;[RED][>30]Standard;[GREEN]Standard I also tried this: [RED][>30]Standard;[BLUE][<-5]Standard;[GREEN]Standard This gives an even worse result since the minus sign is ALWAYS missing. Kind regards Johnny Rosenberg --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org