Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Represents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.
public interface class ConditionValue
[System.Runtime.InteropServices.Guid("00024492-0000-0000-C000-000000000046")] [System.Runtime.InteropServices.InterfaceType(2)] public interface ConditionValue
Public Interface ConditionValue
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(XlConditionValueTypes, Object) method.
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.
Returns a constant in the XlCreator enumeration that indicates the application in which this object was created. Read-only Integer.
Returns the parent object for the specified object. Read-only.
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.
Returns or sets the shortest bar or longest bar threshold value for a data bar conditional format. Read/write Object.
Modifies how the longest bar or shortest bar is evaluated for a data bar conditional formatting rule.