ConditionValue.Modify(XlConditionValueTypes, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

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.

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