ConditionValue.Modify method (Excel)
Modifies how the longest bar or shortest bar is evaluated for a data bar conditional formatting rule.
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. |
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.