GrapeCity.Documents.Excel.IIconCriterion.Value

Value Property

Value

Gets or sets the threshold value for an icon in a conditional format.

The assigned value becomes the threshold for this icon criterion, such as a number, percentage, percentile, or formula value, depending on the criterion type.

Declaration

object Value { get; set; }

Property Value As Object

Examples

IIconSetCondition condition = worksheet.Range["A1:A5"].FormatConditions.AddIconSetCondition();
condition.IconSet = workbook.IconSets[IconSetType.Icon3Symbols];
IIconCriterion criterion = condition.IconCriteria[1];
criterion.Type = ConditionValueTypes.Percent;
criterion.Value = 50;
object value = criterion.Value;