This project has moved and is read-only. For the latest updates, please go here.

Conditional Formatting

Sep 28, 2010 at 11:10 AM

Is it possible to do conditional formatting in EPPlus?

I can't do this at runtime, since the user needs to update certain columns, which will then need to be highlighted based on certain conditions


Sep 28, 2010 at 7:58 PM

No, there is no support for conditional formating in the library.

If you need it, use a template and update the WorksheetXML yourself. (You can check the format by renaming your template.xlsx *.zip and extract it.) 

The ordinary numberformat property supports a simple way of conditional format changing colors depending on Positive, negative and zero values.

Something like this,,,


... but if that's not what you want you have to use the WorksheetXml