Posted 1 August 2022, 2:31 am ESTHi team ,
I am using fromJson() method to get the json data for the sheet. I want to apply 2 different styles in a particular cell . For example , I have a cell with value "200, (-30%)" . In this example, 200 should be in bold and since percentage is a negative number i.e(-30%) it should be in red . I am attaching a screenshot for your reference.
Could you please provide a solution for this?