• Material 3
  • Fluent
  • Fluent 2
  • Bootstrap 5
  • Tailwind CSS
  • High Contrast
  • Fluent 2 High Contrast
Preferences
Mode Selection
Touch
Mouse
Theme Selection
Theme Mode
Localization
*Translated by Google Translator.
Currency

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

This sample demonstrates how to apply conditional formats using XlsIO.
DEMO
SOURCE

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 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.

Features:

  • Writing conditional formatting on a range of cells
  • Advanced options of Excel, such as color scales, icon sets, and data bars
Transform your ASP.NET Core web apps today with Syncfusion® ASP.NET Core components
100+ high-performance and responsive UI components
Dedicated support
Hassle-free licensing
TRY IT FOR FREE
opens in a new tab
Documentation
opens in a new tab
Forum
opens in a new tab
Blog
opens in a new tab
Copyright © 2001-2019 Syncfusion Inc.