Conditional Formatting problem

[Sandra]

Hello. I'm been dealing with a problem when using conditional formatting. I've created a dojo to explain my problem.

https://dojo.telerik.com/UNoCUfiL/2

 

TL;DR of my problem: I have to use this format: "[<-10][RED]##,##0.00\%;[>10][RED]##,##0.00\%;##,##0.00\%". Everytime my cell value is < 10 ([<-10][RED]) or > 10 ([>10][RED]), it loses the negative sign. I can't write any rule based on the value 10, because it will change programmatically.. I'm just giving an example with the value 10.

 

 

Thank you!

[Plamen]

Hi,

It seems like a bug in the Spreadsheet - I have logged it here and you can follow its status there. Please excuse us for the inconvenience caused by the issue. 

Regards,
Plamen
Progress Telerik

[Sandra]

Thank you.