The Syncfusion .NET Excel Library (XlsIO) enables users to apply formatting to cells based on specific conditions dynamically. This feature improves the readability and automation of cell styles in the worksheet.
This example code shows how to apply conditional formatting to an Excel worksheet using the Syncfusion .NET Excel Library with just a few lines of code in C#.
Discover how the conditional formatting features in the Syncfusion Excel Library enhance data visualization by applying dynamic formatting rules to highlight key data based on specific conditions.
Apply conditional formatting to highlight specific cells based on criteria, enhancing data visibility by drawing attention to important values. This makes it easier to identify trends or outliers in your reports.
The top/bottom conditional formatting option emphasizes the highest and lowest values within a selected range, making it useful for quickly identifying top performers or areas that need attention, thereby aiding in data analysis.
Data bars visually represent the magnitude of values in cells by adding colored bars directly within the cells. This provides a quick, at-a-glance understanding of data distribution and comparison across your dataset.
Color scales allow you to apply a gradient color format to cells based on their values, enabling easy comparison and analysis. This helps users visualize data trends and variations effectively.
Icon sets enable you to add visual indicators, such as arrows or symbols, to cells based on their values. This enhances data presentation by providing immediate context and interpretation, making reports more intuitive.
Discover valuable resources from our blog and knowledge base to enhance your efficiency in using conditional formatting.
Knowledge base
Explore these resources for comprehensive guides, knowledge base articles, insightful blogs, and ebooks.
Product Updates
Technical Support
You need to select the maximum number of rows and column values, which are 1,048,576 rows and 16,384 columns, while creating a conditional format using the Syncfusion Excel Library.
The Syncfusion Excel Library supports 5 arrows, 5 arrows gray, 5 boxes,5 quarters, 5 ratings, 4 arrows,4 arrows gray, 4 ratings, 4 red to black, 4 traffic lights, 3 arrows, 3 arrows gray, 3 flags, 3 signs, 3 stars, 3 symbols, 3 symbols 2, 3 traffic lights 1, 3 traffic lights 2, 3 triangles icon sets for creating or editing conditional formatting in Excel documents.
Yes. You can use negative data bar conditional formatting in the Syncfusion Excel Library.
You can add formulas in conditional formatting using FirstFormula and SecondFormula properties using the Syncfusion Excel Library?
The Syncfusion Excel Library supports 2-color scale and 3-color scale types in conditional formatting.
The Syncfusion Excel Library supports context, right to left, and left to right data bar conditional formatting.
Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion® is proud to hold the following industry awards.
