ConditionValue.Modify Method
Excel Developer Reference |
Modifies how the longest bar or shortest bar is evaluated for a data bar conditional formatting rule.
Version Information
Version Added: Excel 2007
Syntax
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. |
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