ConditionValue.Modify(XlConditionValueTypes, Object) Method
Definition
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 |