• Fluent
  • Fluent Dark
  • Bootstrap v5
  • Bootstrap v5 Dark
  • Tailwind CSS
  • Tailwind CSS Dark
  • Material
  • Bootstrap v4
  • High Contrast
Theme Selection
Mode Selection
*Translated by Google Translator.

Example of Conditional Formatting in ASP.NET MVC Excel (XlsIO) Library

This sample demonstrates how to apply conditional formats using Excel (XlsIO) Library.

Click the "Create Document" button to view the created Excel document. Please note that the Microsoft Excel viewer or Microsoft Excel is required to view the Excel document.

Save As :  

Microsoft Office Excel provide enhanced conditional formatting support from Excel 2007 onwards. 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 a single cell in XLSX format, whereas XLS format allows only three conditional formats in a cell.

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


  • Apply conditional formats to a range of cells
  • Advanced options of Excel, such as color scales, icon sets and data bars
  • Format unique and duplicate values in single line