Edit

Share via


ConditionValue.Modify(XlConditionValueTypes, Object) Method

Definition

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

public void Modify (Microsoft.Office.Interop.Excel.XlConditionValueTypes newtype, object newvalue);
Public Sub Modify (newtype As XlConditionValueTypes, Optional newvalue As Object)

Parameters

newtype
XlConditionValueTypes

Specifies how the shortest bar or longest bar is evaluated. The default value is Microsoft.Office.Interop.Excel.XlConditionValueTypes.xlConditionLowestValuefor the shortest bar and Microsoft.Office.Interop.Excel.XlConditionValueTypes.xlConditionHighestValue for the longest bar.

newvalue
Object

The value assigned to the shortest or longest data bar. Depending on the newtype argument, this can be a number or a formula that evaluates to a number.

Remarks

The following table describes the acceptable threshold values for each type of evaluation.

Microsoft.Office.Interop.Excel.XlConditionValueTypes.xlConditionLowestValue argument is ignored
Microsoft.Office.Interop.Excel.XlConditionValueTypes.xlConditionHighestValue argument is ignored
xlConditionValueNumber any number
xlConditionValuePercent any number between 0 and 100
xlConditionValuePercentile any number between 0 and 100
xlConditionValueFormula a formula that returns a single number

Applies to