FontColorRGB Property (IConditionalFormat)

Gets or sets the font color.
Property FontColorRGB As Color
Dim instance As IConditionalFormat
Dim value As Color
instance.FontColorRGB = value
value = instance.FontColorRGB
Color FontColorRGB {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 FontColorRGB property can be used. Colors can be set by creating Color object by specfifying RGB values or can be selected from predefined RGB color objects. FontColor property can be used to set colors that are available from the ExcelKnownColors enumeration.
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 RGB color.
            format.FontColorRGB = Color.FromArgb(255, 0, 0);
            //Save and Dispose.

Syncfusion.XlsIO.Base: 17.1460.0.47

See Also