SetValue(Double,FormatConditionValueType) Method

Sets the Value and ValueType properties to the specified values.

Syntax

Visual Basic

'Declaration
 
Public Overloads Sub SetValue( _
   ByVal value As Double, _
   ByVal valueType As FormatConditionValueType _
) 

C#

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

Exception	Description
System.ArgumentException	If the value type or value is not appropriate for the condition.
System.ArgumentOutOfRangeException	If 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