We are using the jQuery igGrid and have written a manual export to Excel using Infragistics Excel engine. In our igGrid in the browser we are using column templates that mainly paints the cell background colors depending on their values. For numeric columns this rule will have a range such as if 10 > x > 0 and then paints the background of any cell in that column which fits in that range. For string columns we use contains, starts with, ends with etc. to set up these rules. We allow for multiple rules per column, which all have a priority set.

This works fins in the grid but we need it to follow in the Excel export. So basically we have access to all column rules and their respective background colors (both name and HEX available) in our code behind. How do we set conditional formatting in the Infragistics Excel engine? We are using ASP.NET and triggers the export via an AJAX call from the client to an aspx page and we build the workbook in our code behind for that page.