GrapeCity.Documents.Excel.IUniqueValues.NumberFormat

NumberFormat Property

NumberFormat

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

Use this property to retrieve the format code currently configured for a unique-values or duplicate-values conditional formatting rule.

Declaration

string NumberFormat { get; set; }

Property NumberFormat As String

Examples

worksheet.Range["A1:A5"].Value = new object[,] {
    {100}, {100}, {200}, {300}, {300}
};
IUniqueValues condition = worksheet.Range["A1:A5"].FormatConditions.AddUniqueValues();
condition.Interior.Color = Color.Yellow;
condition.NumberFormat = "0.00";
string numberFormat = condition.NumberFormat;