Defines the criterion for a 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; }FormatColor
Section titled "FormatColor"Returns or sets a object which defines the color information for the threshold associated with this instance.
public WorkbookColorInfo FormatColor { get; set; }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
Returns any
ToString()
Section titled "ToString()"Returns the string representation of this instance.
public override string ToString()