...
Description |
---|
Excerpt |
---|
Resets the current Condition's Comparison type and minimum and maximum formulas. The method takes two formulas, and therefore must take a |
Signature | ||||
---|---|---|---|---|
| ||||
public void ChangeCondition(Comparison comparisonType, System.String formula1, System.String formula2)
{signature}{signature: |
Signature | ||||||
---|---|---|---|---|---|---|
| }
| |||||
Public Sub ChangeCondition(ByVal comparisonType As Comparison, ByVal formula1 As String, ByVal formula2 As String)
{signature}
{parameters}
{param:comparisonType}The type of comparison Excel will use when comparing a cell value to {{formula1}} and {{formula2}}. The comparison type must require two formulas and may be set to one of the following values: {{Comparison.CellValueBetween}} or [Comparison.CellValueNotBetween|Condition.Comparison#CellValueNotBetween].{param}
{param:formula1}The formula to use for the minumum value.{param}
{param:formula2}The formula to use for the maximum value.{param}
{example}{code:csharp|title=C#} |
Parameters |
---|
Param | ||||
---|---|---|---|---|
| ||||
The type of comparison Excel will use when comparing a cell value to |
Param | ||||
---|---|---|---|---|
| ||||
The formula to use for the minumum value. |
Param | ||||
---|---|---|---|---|
| ||||
The formula to use for the maximum value. |
Example | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|