ConditionValue Object
Excel Developer Reference |
Represents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.
Version Information
Version Added: Excel 2007
Remarks
The ConditionValue object is returned using either the MaxPoint or MinPoint property of the Databar object.
You can change the type of evaluation from the default setting (lowest value for the shortest bar and highest value for the longest bar) by using the Modify method.
Example
The following example creates a range of data and then applies a data bar to the range. You will notice that because there is an extremely low and high value in the range, the middle values have data bars that are of similiar length. To disambiguate the middle values, the sample code uses the ConditionValue object to change how the thresholds are evaluated to percentiles.
Visual Basic for Applications |
---|
|
See Also