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.

newtype argument	newvalue argument
xlConditionLowestValue	argument is ignored
xlConditionHighestValue	argument is ignored
xlConditionValueNumber	any number
xlConditionValuePercent	any number between 0 and 100
xlConditionValuePercentile	any number between 0 and 100
xlConditionValueFormula	a formula that returns a single number

See Also

Reference

ConditionValue Interface

ConditionValue Members

Microsoft.Office.Interop.Excel Namespace