FlexSheet supports conditional formatting on the client side, that allows you to change the formatting of a cell or a range of cells depending on the value of the cell(s) or formula applied on the cell(s). Applying conditional formatting to FlexSheet control empowers you to boost its capabilities, thereby enabling you to do more than what you could do using its built-in functionality.

For example, while maintaining expenses and sales record for your retail store, you can easily track when your actual expenses are shooting over the budgeted expenses. The below example demonstrates this scenario.

The following image shows FlexSheet control displaying expenses details for a retail store, with conditional formatting applied on cells having values greater than 1000.
<image>

The following code examples demonstrate how to add conditional formatting in FlexSheet.

In Code

ConditionalFormatController.cs 

Type your example code here. It will be automatically colorized when you switch to Preview or build the help system.

ConditionalFormatting.cshtml

Type your example code here. It will be automatically colorized when you switch to Preview or build the help system.

Back to Top