Conditional Formatting ‐ Colors

This page has moved. The current version of this page is at https://epplussoftware.com/docs/styling/conditional-formatting/colors/. The EPPlus documentation is no longer updated in this wiki; please use the EPPlus guides and update your bookmarks.

Conditional formattings can apply other colors than just .Color. You can also apply theme, index or auto color.

Here's an example of applying theme color using .Theme instead on an AboveAverageRule:

using (var pck = new ExcelPackage())
{
   var sheet = pck.Workbook.Worksheets.Add("NewWorksheet");

   var cf = sheet.ConditionalFormatting.AddAboveAverage("A1:B5");

   cf.Style.Fill.BackgroundColor.Theme = eThemeSchemeColor.Accent4;
}

The same logic applies to most other conditional formattings, with the exception of Databars and Colorscales.

As of EPPlus 7.0 databars and color scales have built-in support for theme, index or auto color options.

Here are some examples of applying theme colors on:

A databar:

var cfDatabar = sheet.ConditionalFormatting.AddDatabar("A1:B5", Color.Red);

cfDatabar.FillColor.Theme = eThemeSchemeColor.Accent1;
cfDatabar.BorderColor.SetColor(eThemeSchemeColor.Accent2);

A ThreeColorScale:

var threeColor = sheet.ConditionalFormatting.AddThreeColorScale("A1:B5");

threeColor.LowValue.ColorSettings.Theme = eThemeSchemeColor.Background1;
threeColor.MiddleValue.ColorSettings.Theme = eThemeSchemeColor.Accent2;
threeColor.HighValue.ColorSettings.Theme = eThemeSchemeColor.Accent3;

Note that there are some differences in how to set the colors due to ensuring backwards compatibility, and because Databars has multiple options on one whole whereas colorScale has different needs as these two are more complex and diverse types.

Back to Conditional Formatting