Show / Hide Table of Contents

Conditional Formatting Color Scale

Output: ConditionalFormattingColorScale.xlsx

public void Run()
{
    var workbook = new Workbook();
    var worksheet = workbook.Worksheets[0];
    worksheet.Columns[0].WidthCharacters = 40;
    worksheet.Columns.SetWidthCharacters("B", "F", 5);

    worksheet["A1"].Value = "Two Color Scale Blue Yellow Lowest Highest";
    worksheet.GetRange("B1:F1").SetValue(new int[] {1, 2, 3, 4, 5});
    worksheet.ConditionalFormattings.AddTwoColorScale("B1:F1", SpreadsheetColor.Blue, SpreadsheetColor.Yellow);

    worksheet["A2"].Value = "Two Color Scale Blue Yellow 20%-80%";
    worksheet.GetRange("B2:F2").SetValue(new[] {1, 2, 3, 4, 5});
    var ruleB2 = worksheet.ConditionalFormattings.AddTwoColorScale("B2:F2", SpreadsheetColor.Blue,
                    SpreadsheetColor.Yellow);
    ruleB2.Minimum.Type = ConditionValueType.Percent;
    ruleB2.Maximum.Type = ConditionValueType.Percent;
    ruleB2.Minimum.Value = 20;
    ruleB2.Maximum.Value = 80;

    worksheet["A3"].Value = "Three Color Scale Red Yellow Green";
    worksheet.GetRange("B3:F3").SetValue(new[] {1, 2, 3, 4, 5});
    worksheet.ConditionalFormattings.AddThreeColorScale("B3:F3", SpreadsheetColor.Red,           SpreadsheetColor.Yellow, SpreadsheetColor.Green);

    workbook.SaveAs("ConditionalFormattingColorScale.xlsx");
}
Back to top Generated by DocFX