.NET Excel Library - Excel Conditional Formatting in C#
- Format cells based on specific conditions.
- Add advanced conditional formats such as color scale, data bars, and icons.
- Use formulas and named ranges in conditional formatting.
Try C# Excel Examples in Playground app.
FREE TRIALNo credit card required.
Explore ExamplesNo credit card required.
Trusted by the worldโs leading companies
.NET excel library conditional formatting
Overview
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.
Conditional formatting Code Example
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#.
Key features of conditional formatting
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.
Highlight cells
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.
Top/Bottom
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
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
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
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.
Explore Conditional Formatting References
Discover valuable resources from our blog and knowledge base to enhance your efficiency in using conditional formatting.
๐ Easiest Ways to Highlight Data in Excel Using C#
Blog
Easiest Ways to Highlight Data in Excel Using C#
๐ Set criteria for icon set conditional formats in Excel using XlsIO
Knowledge base
How to set criteria for icon set conditional formats in Excel using XlsIO
๐ Set conditional formatting for text in C#, VB.NET
Knowledge base
Set conditional formatting for text in C#, VB.NET;
๐ Set conditional formatting for numbers
Knowledge base
How to set conditional formatting for numbers
๐ Set multiple-condition formatting using C#, VB.NET
Knowledge base
How to set multiple-condition formatting using C#, VB.NET
Explore these resources for comprehensive guides, knowledge base articles, insightful blogs, and ebooks.
Frequently Asked Questions
How do I apply conditional formatting for an entire worksheet using the Syncfusion Excel Library?
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.
What types of icons are supported in 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.
Is negative bar formatting supported in data bar conditional formatting?
Yes. You can use negative data bar conditional formatting in the Syncfusion Excel Library.
How do I provide formulas in conditional formatting using the Syncfusion Excel Library?
You can add formulas in conditional formatting using FirstFormula and SecondFormula properties using the Syncfusion Excel Library?
How many color scales in conditional formatting are supported in the Syncfusion Excel Library?
The Syncfusion Excel Library supports 2-color scale and 3-color scale types in conditional formatting.
What are the directions for data bar conditional formatting supported in the Syncfusion Excel Library?
The Syncfusion Excel Library supports context, right to left, and left to right data bar conditional formatting.
Our Customers Love Us
Here are some of their experiences.
See Real Success Stories
Developers around the world trust Syncfusionโs Essential Studio to simplify complex projects and speed up delivery. With a vast library of UI controls, powerful SDKs, and reliable support, Essential Studio helps teams build enterprise-ready applications with confidence.
Read Our Customer StoriesIndustry
Software development
75% Cost reduction
50% Faster development
โIf somebody is looking for a great tool to work with? Yes. I would definitely recommend Syncfusion for anyone who is trying to develop something meaningful.โ
- Somnath Maji (Founder of Igniatek Consultancy)
Read StoryIndustry
Utilities (oil and gas)
Advanced, flexible features
Empowered users through robust and versatile functionality.
โSyncfusionโs tools have taken care of many things so I can focus on developing the application, instead of developing tools for the application.โ
- James Athyal (Software developer, McDaniel & Associates Consultants Ltd)
Read StoryIndustry
Software and technology
Efficient file management
Streamlined workflows with document libraries without building them from scratch.
โWe really love when the magic happens.โ
- Irvin Dominin (BUILDER WEB Development Manager at Sistemi)
Read StoryIndustry
Software and technology
โWe are Syncfusion fans because of the way Syncfusion treats the support.โ
- Dr. Howard Rybko (CEO of Synchrony Digital)
Read StoryIndustry
IT services and IT consulting
Improved performance
Large datasets handled with easy customization and quick debugging.
Highly customizable
Plug-and-play controls with quick template integration.
โI will surely recommend Syncfusion to others as a third-party control because I think itโs very easily customizable.โ
- Jayesh (Technical Team Lead, Capita)
Read StoryIndustry
Professional services
โWe definitely wanted Syncfusion to help us with our document processing functionality, and we were happy with and satisfied with Syncfusion.โ
- Arvind Naik (Engineering Lead, Vialto Partners)
Read StoryRated by users across the globe
Want to create, View, and edit Excel files in C# or VB.NET?
No credit card required.
Awards
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.
