Syncfusion.XlsIO.Base
Example 


LeftBorderColorRGB Property (IConditionalFormat)

Gets or sets the left border RGB color.
Syntax
'Declaration
 
Property LeftBorderColorRGB As Color
'Usage
 
Dim instance As IConditionalFormat
Dim value As Color
 
instance.LeftBorderColorRGB = value
 
value = instance.LeftBorderColorRGB
Color LeftBorderColorRGB {get; set;}
Example
To set left border color for the cell within conditional formatting range from the RGB colors we use LeftBorderColorRGB property. Colors from ExcelKnownColors enumeration can be applied by using LeftBorderColor property.
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;
            
            //Apply Conditional format.
            format.BottomBorderStyle = ExcelLineStyle.Thick;
            format.LeftBorderStyle = ExcelLineStyle.Thick;
            format.TopBorderStyle = ExcelLineStyle.Thick;
            format.RightBorderStyle = ExcelLineStyle.Thick;
                
            //Set Border color.
            format.BottomBorderColorRGB = Color.Red;
            format.LeftBorderColorRGB = Color.Red;  //Set RGB color.
            format.RightBorderColorRGB = Color.Red;
            format.TopBorderColorRGB = Color.Red; 
            
            //Save and Dispose.
            workbook.SaveAs("ConditionalFormats.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also