GrapeCity.Documents.Excel.IAboveAverage.NumberFormat

NumberFormat Property

NumberFormat

Gets or sets the number format applied to a cell if the conditional formatting rule evaluates to true.

Use this property to retrieve the format code currently configured for an above-average conditional formatting rule.

Declaration

string NumberFormat { get; set; }

Property NumberFormat As String

Examples

worksheet.Range["A1:A5"].Value = new object[,] {{10}, {20}, {30}, {40}, {50}};
IAboveAverage format = worksheet.Range["A1:A5"].FormatConditions.AddAboveAverage();
format.Interior.Color = Color.Yellow;
format.NumberFormat = "0.00";
string numberFormat = format.NumberFormat;