Syncfusion.XlsIO.Base
Example 


BottomBorderColor Property (IConditionalFormat)

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

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also