• Material
  • Fabric
  • Bootstrap
  • High Contrast
Theme Selection
Mode Selection


This sample demonstrates how to apply conditional formats using XlsIO.
Click the button to view an Excel spreadsheet generated by Essential XlsIO. Please note that Microsoft Excel Viewer or Microsoft Excel is required to view the resultant document.

Save As :

Microsoft Excel provides enhanced conditional formatting support. Conditional formatting allows you to apply formatting to one or more cells based on the value of the cell or the value of a formula. XlsIO also supports applying more than three conditional formats to the same cell, similar to Excel 2007 and above.

Note: It is not possible to apply more than three conditional formats in earlier versions of Excel.


  • Writing conditional formatting on a range of cells
  • Advanced options of Excel, such as color scales, icon sets, and data bars