Conditional Formatting

Applying Conditional Formatting

Aspose.Cells supports conditional formatting in two ways:

Using Designer Spreadsheet

Developers can create a designer spreadsheet that contains conditional formatting in Microsoft Excel and then open that spreadsheet with Aspose.Cells. Aspose.Cells loads and saves the designer spreadsheet, keeping any conditional formatting setting. To find out more about designer spreadsheets, read What is a Designer Spreadsheet.

Applying Conditional Formatting at Runtime

Aspose.Cells supports applying conditional formatting at runtime.

Set Font

Setting fonts in Microsoft Excel


Set Border

Setting borders in Microsoft Excel


Set Pattern

Setting a cell pattern in Microsoft Excel


Advance topics