Syncfusion.XlsIO.Base
Example 


ColorRGB Property (IConditionalFormat)

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

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also