1. Home
  2. Forum
  3. jQuery
  4. conditional formatting

conditional formatting

Hi 

I tried to open an existing excel file in html , It imported the data ,but the conditional formatting in the excel file is not imported . Do i have to do it manually ?(using xlformat or xlcformat)
the formula I used in excel is 
          =IF(M7<0,M7,"")  ,if this condition is met , highlight the cell or entire row

Thanks

1 Reply
SI Silambarasan I Syncfusion Team October 20, 2017 11:34 AM UTC

Hi Sumaira, 
 
Thank you for using Syncfusion products. 
 
We have checked the reported query and currently we have provided the support for applying Conditional formatting with simple formulas (e.g: =A1>1) in Spreadsheet. And, the support for using complex formulas (i.e using predefined formula like =IF()) is not currently available in Spreadheet. However, we have added it to our feature request list, and it’ll be available in any of our upcoming releases. 
 
Regards, 
Silambarasan 


Loader.
Up arrow icon