Syncfusion.XlsIO.Base
Example 


Color Property (IConditionalFormat)

Gets or sets the pattern foreground color from predefined colors (ExcelKnownColors).
Syntax
'Declaration
 
Property Color As ExcelKnownColors
'Usage
 
Dim instance As IConditionalFormat
Dim value As ExcelKnownColors
 
instance.Color = value
 
value = instance.Color
ExcelKnownColors Color {get; set;}
Example
Color property is used to set the foreground color for FillPattern based on the condition applied. RGB color can be applied by setting RGB color to ColorRGB property. Here for example, we set ExcelPattern.DarkHorizontal to FillPattern and ExcelKnownColors.Red to Color.
using Syncfusion.XlsIO;
            
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 Pattern.
            format.FillPattern = ExcelPattern.DarkHorizontal;
            
            //Set Color.
            format.Color = ExcelKnownColors.Red;
            
            //Save and Dispose.
            workbook.SaveAs("ConditionalFormats.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also