Version

SetValue(Double,FormatConditionValueType) Method

Sets the Value and ValueType properties to the specified values.
Syntax
'Declaration
 
Public Overloads Sub SetValue( _
   ByVal value As Double, _
   ByVal valueType As FormatConditionValueType _
) 
public void SetValue( 
   double value,
   FormatConditionValueType valueType
)

Parameters

value
The new value for the Value property.
valueType
The new value for the ValueType property. Must be set to either Number, Percentage, or Percentile or an exception is thrown.
Exceptions
ExceptionDescription
System.ArgumentExceptionIf the value type or value is not appropriate for the condition.
System.ArgumentOutOfRangeExceptionIf the value is out of range.
Remarks

To set the ValueType property to Formula, use the SetFormula method.

To set the ValueType property to a FormatConditionValueType value for which the Value is not applicable, use the SetValue(FormatConditionValueType) method.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also