This project has moved. For the latest updates, please go here.

How to get the conditional formatting applied to the cell?

Apr 24, 2014 at 8:22 AM
I'm decomposing an Excel workbook using EPPlus. One of the worksheets has many existing conditional formatting rules which have been setup in Excel.

When iterating over cells I can't seem to locate the attributes which have been altered by the conditional formatting rules although when I save the package and open the Excel file the formatting is applied to the cells.

Is it possible to get the values post conditional formatting using EPPlus? For example, one of the rules may check if the value of the cell value is greater than 0.05 and if it is the cell colour is formatted red, otherwise green. I would expect the Cell.Style.Fill.BackgroundColor.Rgb property to have a red value.