Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IDataBar Interface : NegativeFillColor Property

NegativeFillColor Property

Gets or sets the negative fill color of the data bar. This element MUST exist if and only if negativeBarColorSameAsPositive equals "false".
Syntax
'Declaration
 
Property NegativeFillColor As Color
'Usage
 
Dim instance As IDataBar
Dim value As Color
 
instance.NegativeFillColor = value
 
value = instance.NegativeFillColor
Color NegativeFillColor {get; set;}
Remarks
To customize the border color and fill color of the DataBar we can use BorderColor and BarColor properties.
Example
To customize color for DataBar which has negative values in the cells, we have to set color for NegativeBorderColor and NegativeFillColor properties. Here in our example, to show Databar for negative values we are setting red color for NegativeFillColor property.
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 NegativeBar color for DataBar
            dataBar.NegativeFillColor = Color.Red;
            
            //Save and Dispose.
            workbook.SaveAs("ConditionalFormats.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also