...
Description |
---|
Excerpt |
---|
Creates a Condition of the specified ComparisonType. |
Signature | ||||
---|---|---|---|---|
| ||||
public Condition CreateCondition(Comparison comparisonType, System.String formula1, System.String formula2)
{signature}{signature: |
Signature | ||||||
---|---|---|---|---|---|---|
| }
| |||||
Public Function CreateCondition(ByVal comparisonType As Comparison, ByVal formula1 As String, ByVal formula2 As String) As Condition
{signature}
{parameters}
{param:comparisonType}A [Condition] constant representing the type of comparison Excel will use when comparing a cell value to the parameters {{formula1}} and {{formula2}}. The comparison type must require two formulas and may be set to one of the following values: [Condition.Comparison.CellValueBetween|Condition.Comparison#CellValueBetween] or [Condition.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}
{returns}A [Condition|Condition] object representing the condition created.{returns}
{example}{code:csharp|title=C#} |
Parameters |
---|
Param | ||||
---|---|---|---|---|
| ||||
A Condition constant representing the type of comparison Excel will use when comparing a cell value to the parameters |
Param | ||||
---|---|---|---|---|
| ||||
The formula to use for the minumum value. |
Param | ||||
---|---|---|---|---|
| ||||
The formula to use for the maximum value. |
Returns |
---|
A Condition object representing the condition created. |
Example | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|