FontColor Property (IConditionalFormat)

Gets or sets the font color from predefined colors (ExcelKnownColors).
Property FontColor As ExcelKnownColors
Dim instance As IConditionalFormat
Dim value As ExcelKnownColors
instance.FontColor = value
value = instance.FontColor
ExcelKnownColors FontColor {get; set;}
Similar to FontColor and FontColorRGB properties, cell colors can be set using BackColor and BackColorRGB properties.
To set font color for the text in the cells within the conditional formatting range FontColor property can be used. Colors can be selected from the ExcelKnownColors enumeration which has all the colors that are included in Excel by default. FontColorRGB property can be used to set colors in RGB representation.
using Syncfusion.XlsIO;
using System;
using System.Drawing;
class Example
    static void Main()
        using (ExcelEngine excelEngine = new ExcelEngine())
            //Create a worksheet.        
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;
            IWorkbook workbook = application.Workbooks.Create(1);
            IWorksheet worksheet = workbook.Worksheets[0];
            //Load data to Apply Conditional Formatting.
            worksheet["B1"].Text = "Conditional Formats";
            worksheet["B2"].Number = 10;
            worksheet["B3"].Number = 20;
            worksheet["B4"].Number = 30;
            worksheet["B5"].Number = 40;
            worksheet["B6"].Number = 50;
            worksheet["B7"].Number = 60;
            worksheet["B8"].Number = 70;
            worksheet["B9"].Number = 80;
            worksheet["B10"].Number = 90;
            worksheet["B11"].Number = 100;
            //Create instance of IConditonalFormat and IConditionalFormats.
            IConditionalFormats formats = worksheet["B2:B11"].ConditionalFormats;
            IConditionalFormat format = formats.AddCondition();
            //Set Condition.
            format.FirstFormula = "60";
            format.SecondFormula = "20";
            format.Operator = ExcelComparisonOperator.Between;
            //Set Color.
            format.FontColor = ExcelKnownColors.Red;
            //Save and Dispose.

Syncfusion.XlsIO.Base: 17.1460.0.47

See Also