Syncfusion.XlsIO.Base
Example 


FontColor Property (IConditionalFormat)

Gets or sets the font color from predefined colors (ExcelKnownColors).
Syntax
'Declaration
 
Property FontColor As ExcelKnownColors
'Usage
 
Dim instance As IConditionalFormat
Dim value As ExcelKnownColors
 
instance.FontColor = value
 
value = instance.FontColor
ExcelKnownColors FontColor {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 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.
            workbook.SaveAs("ConditionalFormats.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.47

See Also