Defines the criterion for an threshold.
Inheritance
object
Properties
Section titled "Properties"Value
Section titled "Value"Inherited from: CriterionBase
Returns the numeric value for this instance.
public double Value { get; }ValueType
Section titled "ValueType"Inherited from: CriterionBase
Returns a value which specifies the manner in which the threshold values for this instance are determined.
public FormatConditionValueType ValueType { get; }Formula
Section titled "Formula"Inherited from: CriterionBase
Returns the which determines whether cell values meet the criteria defined by the associated condition.
public Formula Formula { get; }Comparison
Section titled "Comparison"Returns or sets a value which determines whether a "greater than" or "greater than or equal to" comparison is made when comparing cell values to the of this instance.
public ThresholdComparison Comparison { get; set; }Returns or sets a value which identifies the icon displayed for this threshold as defined by the and properties.
public FormatConditionIcon Icon { get; set; }IconSet
Section titled "IconSet"Returns a value which identifies the icon set that includes this icon (read-only).
public FormatConditionIconSet IconSet { get; }Methods
Section titled "Methods"SetFormula(string, CellReferenceMode?, FormatConditionValueType)
Section titled "SetFormula(string, CellReferenceMode?, FormatConditionValueType)"Inherited from: CriterionBase
Assigns the specified formula to the property, and assigns a value of Formula to the property.
public void SetFormula(string formula, CellReferenceMode? cellReferenceMode = null, FormatConditionValueType valueType = FormatConditionValueType.Formula)Parameters
- formula:
string - cellReferenceMode:
CellReferenceMode? - valueType:
FormatConditionValueType
Returns any
SetValue(double, FormatConditionValueType)
Section titled "SetValue(double, FormatConditionValueType)"Inherited from: CriterionBase
Sets the and properties to the specified values.
public void SetValue(double value, FormatConditionValueType valueType)Parameters
- value:
double - valueType:
FormatConditionValueType
Returns any
SetValue(FormatConditionValueType)
Section titled "SetValue(FormatConditionValueType)"Inherited from: CriterionBase
Sets the property to the specified value.
public void SetValue(FormatConditionValueType valueType)Parameters
- valueType:
FormatConditionValueType