Syncfusion.XlsIO.Base
Example 


IsFontColorPresent Property

True if font color is present. otherwise, False.
Syntax
'Declaration
 
Property IsFontColorPresent As Boolean
'Usage
 
Dim instance As IConditionalFormat
Dim value As Boolean
 
instance.IsFontColorPresent = value
 
value = instance.IsFontColorPresent
bool IsFontColorPresent {get; set;}
Example
using Syncfusion.XlsIO;
using System;
            
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;
            
            //Check Font color is present or not.
            Console.WriteLine(format.IsFontColorPresent);
            
            //Set Color.
            format.FontColor = ExcelKnownColors.Red;
            
            //Check Font color is present or not.
            Console.WriteLine(format.IsFontColorPresent);
            
            //Save and Dispose.
            workbook.SaveAs("ConditionalFormats.xlsx");
            workbook.Close();
        }
    }
}
//Output will be
//False
//True
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also