Condition Value Properties

Name

Returns

Description

Type xlConditionValueTypes

Value

Variant

Specifies how the threshold values for a data bar conditional format are determined (number, percent, formula, or percentile). This property will return an xlConditionValueTypes constant. Read-only

Set/Get the shortest bar or longest bar threshold value for a data bar conditional format. You can only set this value if the condition value type is set to number, percent, percentile, or formula

0 0

Post a comment