ConditionValue.Modify Method

Modifies how the longest bar or shortest bar is evaluated for a data bar conditional formatting rule.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub Modify ( _
    newtype As XlConditionValueTypes, _
    newvalue As Object _
)
'Usage
Dim instance As ConditionValue
Dim newtype As XlConditionValueTypes
Dim newvalue As Object

instance.Modify(newtype, newvalue)

void Modify(
    XlConditionValueTypes newtype,
    Object newvalue
)

Parameters

• newtype
  Type: Microsoft.Office.Interop.Excel.XlConditionValueTypes

  Specifies how the shortest bar or longest bar is evaluated. The default value is xlConditionLowestValuefor the shortest bar and xlConditionHighestValue for the longest bar.

• newvalue
  Type: System.Object

  The value assigned to the shortest or longest data bar. Depending on the newtype argument, this can be a number or a formula that evaluates to a number.

Remarks

The following table describes the acceptable threshold values for each type of evaluation.

See Also

Reference

ConditionValue Interface

ConditionValue Members

Microsoft.Office.Interop.Excel Namespace