Syncfusion.XlsIO Namespace > IDataBar Interface : NegativeBorderColor Property

NegativeBorderColor Property

Gets or sets the negative border color of the data bar.
Property NegativeBorderColor As Color
Dim instance As IDataBar
Dim value As Color
instance.NegativeBorderColor = value
value = instance.NegativeBorderColor
Color NegativeBorderColor {get; set;}
To change fill color and border color of DataBars use BarColor and BorderColor properties.
There will be no borders applied to ColorBars initially. Like BorderColor property used to set border color for positive values in the cells NegativeBorderColor property is used to set border color for negative values in the cells. Here in our example, we set NegativeBorderColor to Yellow.
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["A1"].Text = "DataBar";
            worksheet["A2"].Number = 10;
            worksheet["A3"].Number = -20;
            worksheet["A4"].Number = -30;
            worksheet["A5"].Number = 40;
            worksheet["A6"].Number = -50;
            worksheet["A7"].Number = 60;
            worksheet["A8"].Number = -70;
            worksheet["A9"].Number = 80;
            worksheet["A10"].Number = -90;
            worksheet["A11"].Number = 100;
            //Create instance of IConditonalFormat and IConditionalFormats.
            IConditionalFormats formats = worksheet["A2:A11"].ConditionalFormats;
            IConditionalFormat format = formats.AddCondition();
            //Set FormatType as DataBar.
            format.FormatType = ExcelCFType.DataBar;
            IDataBar dataBar = format.DataBar;
            //Set NegativeBorder color for DataBar
            dataBar.NegativeBorderColor = Color.Yellow;
            //Save and Dispose.

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also