Exposes properties which define the value and its unit of measure for a conditional format threshold.
Inheritance
object
Properties
Section titled "Properties"Formula
Section titled "Formula"Returns the which determines whether cell values meet the criteria defined by the associated condition.
public Formula Formula { get; }Value
Section titled "Value"Returns the numeric value for this instance.
public double Value { get; }ValueType
Section titled "ValueType"Returns a value which specifies the manner in which the threshold values for this instance are determined.
public FormatConditionValueType ValueType { get; }Methods
Section titled "Methods"SetFormula(string, CellReferenceMode?, FormatConditionValueType)
Section titled "SetFormula(string, CellReferenceMode?, FormatConditionValueType)"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(FormatConditionValueType)
Section titled "SetValue(FormatConditionValueType)"Sets the property to the specified value.
public void SetValue(FormatConditionValueType valueType)Parameters
- valueType:
FormatConditionValueType
Returns any
SetValue(double, FormatConditionValueType)
Section titled "SetValue(double, FormatConditionValueType)"Sets the and properties to the specified values.
public void SetValue(double value, FormatConditionValueType valueType)Parameters
- value:
double - valueType:
FormatConditionValueType
Returns any
ToString()
Section titled "ToString()"Returns the string representation of this instance.
public override string ToString()