ConditionValue.Modify Method (Excel)

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

Version Added: Excel 2007

expression .Modify(newtype, newvalue)

expression A variable that represents a ConditionValue object.

Parameters

Name

Required/Optional

Data Type

Description

newtype

Required

XlConditionValueTypes

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

newvalue

Optional

Variant

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.

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

Show:
© 2014 Microsoft