Syncfusion.XlsIO.Base
Example 


FontColorRGB Property (IConditionalFormat)

Gets or sets the font color.
Syntax
'Declaration
 
Property FontColorRGB As Color
'Usage
 
Dim instance As IConditionalFormat
Dim value As Color
 
instance.FontColorRGB = value
 
value = instance.FontColorRGB
Color FontColorRGB {get; set;}
Remarks
Similar to FontColor and FontColorRGB properties, cell colors can be set using BackColor and BackColorRGB properties.
Example
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.
            workbook.SaveAs("ConditionalFormats.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also