ConditionValue Object Members

  • Article
Excel Developer Reference

Represents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.

Methods

  Name Description
Bb255939.methods(en-us,office.12).gif Modify Modifies how the longest bar or shortest bar is evaluated for a data bar conditional formatting rule.

Properties

  Name Description
Bb255939.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Office Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.
Bb255939.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb255939.properties(en-us,office.12).gif Type Returns one of the constants of the XlConditionValueTypes enumeration, which specifies how the threshold values for a data bar, color scale, or icon set conditional format are determined. Read-only.
Bb255939.properties(en-us,office.12).gif Value Returns or sets the shortest bar or longest bar threshold value for a data bar conditional format. Read/write Variant.