GrapeCity.Documents.Excel.IDataBar.NegativeBarFormat

NegativeBarFormat Property

NegativeBarFormat

Gets the negative bar format settings for this data bar conditional formatting rule.

Use the returned INegativeBarFormat object to configure the fill color and border color behavior for negative values in the data bar.

Declaration

INegativeBarFormat NegativeBarFormat { get; }

ReadOnly Property NegativeBarFormat As INegativeBarFormat

Examples

worksheet.Range["A1:A4"].Value = new object[,] {{-10}, {-5}, {0}, {20}};
IDataBar dataBar = worksheet.Range["A1:A4"].FormatConditions.AddDatabar();
INegativeBarFormat negativeBarFormat = dataBar.NegativeBarFormat;
negativeBarFormat.ColorType = DataBarNegativeColorType.Color;
negativeBarFormat.Color.Color = Color.Red;