GrapeCity.Documents.Excel.INegativeBarFormat.Color

Color Property

Color

Gets a FormatColor object that you can use to specify the fill color for negative data bars.

Use the returned IFormatColor object to customize the dedicated fill color when ColorType is set to Color.

Declaration

IFormatColor Color { get; }

ReadOnly Property Color As IFormatColor

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;
IFormatColor color = negativeBarFormat.Color;
color.Color = Color.Red;