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.