Skip to content

Latest commit

 

History

History
31 lines (13 loc) · 910 Bytes

376dccc8-2d47-c7ed-1b14-d41dcdd1a8ff.md

File metadata and controls

31 lines (13 loc) · 910 Bytes

ConditionValue.Value Property (Excel)

Returns or sets the shortest bar or longest bar threshold value for a data bar conditional format. Read/write Variant .

Syntax

expression . Value

expression A variable that represents a ConditionValue object.

Remarks

You can set the value only if the ConditionValue.Type property for the conditional format is set to one of the following constants: xlConditionValueNumber , xlConditionValuePercent , xlConditionValuePercentile , or xlConditionValueFormula .

If the threshold type is a formula, you can set the formula as a String . The formula must return a single number.

See also

Concepts

ConditionValue Object

Other resources

ConditionValue Object Members