Syncfusion.XlsIO.Base
Example 


BackColorRGB Property (IConditionalFormat)

Gets or sets the background RGB color.
Syntax
'Declaration
 
Property BackColorRGB As Color
'Usage
 
Dim instance As IConditionalFormat
Dim value As Color
 
instance.BackColorRGB = value
 
value = instance.BackColorRGB
Color BackColorRGB {get; set;}
Remarks
Similar to BackColorRGB property, we can use BackColor property. In BackColor we can only select a color from ExcelKnownColors enumeration . But, in BackColorRGB we can create RGB color objects by changing RGB values.
Example
BackColorRGB property is used to set RGB color to the cell's background, if the conditions of conditional formats get satisfied.
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 RGB color.
            format.BackColorRGB = Color.FromArgb(255, 0, 0);
            
            //Save and Dispose.
            workbook.SaveAs("ConditionalFormats.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.47

See Also