Signature |
---|
C# | C# | Wiki Markup |
---|
{description}
{excerpt}Creates a [Condition] of the specified [ComparisonType|Condition.ComparisonType].{excerpt}
{signature:C#}
public Condition CreateCondition(Comparison comparisonType, System.String formula)
|
Signature |
---|
{signature}{signature:vb.net | vb.net | }
Public Function CreateCondition(ByVal comparisonType As Comparison, ByVal formula As String) As Condition
|
...
A Condition constant representing the type of comparison Excel will use when comparing a cell value to the result of the parameter formula
. The comparison type must require only one formula and may be set to one of the following values: Condition.Comparison.FormulaEvaluates, Condition.Comparison.CellValueLessThan, Condition.Comparison.CellValueGreaterThan, Condition.Comparison.CellValueLessThanOrEqualTo, Condition.Comparison.CellValueGreaterThanOrEqualTo, Condition.Comparison.CellValueEqualTo, or Condition.Comparison.CellValueNotEqualTo.
...
The result of this formula will be compared to each cell value in the set of cells associated with the conditional format.
Returns |
---|
A Condition object representing the condition created. |
Example |
---|
Code Block |
---|
| csharp | csharp |
title | C# |
---|
{signature}
{parameters}
{param:comparisonType}A [Condition] constant representing the type of comparison Excel will use when comparing a cell value to the result of the parameter {{formula}}. The comparison type must require only one formula and may be set to one of the following values: [Condition.Comparison.FormulaEvaluates|Condition.Comparison#FormulaEvaluates], [Condition.Comparison.CellValueLessThan|Condition.Comparison#CellValueLessThan], [Condition.Comparison.CellValueGreaterThan|Condition.Comparison#CellValueGreaterThan], [Condition.Comparison.CellValueLessThanOrEqualTo|Condition.Comparison#CellValueLessThanOrEqualTo], [Condition.Comparison.CellValueGreaterThanOrEqualTo|Condition.Comparison#CellValueGreaterThanOrEqualTo], [Condition.Comparison.CellValueEqualTo|Condition.Comparison#CellValueEqualTo], or [Condition.Comparison.CellValueNotEqualTo|Condition.Comparison#CellValueNotEqualTo].
{param}
{param:formula}The result of this formula will be compared to each cell value in the set of cells associated with the conditional format.{param}
{returns}A [Condition|Condition] object representing the condition created.{returns}
{example}{code:csharp|title=C#}
ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Create();
Range rng = wb.Worksheets[0].CreateRange("$B$2:$F$10");
ConditionalFormat condFmt = wb.CreateConditionalFormat();
Condition cond =
condFmt.CreateCondition(
Condition.Comparison.CellValueGreaterThan,
"=100");
Font fnt = cond.Style.Font;
fnt.Bold = true;
fnt.Color = wb.Palette.GetClosestColor(100, 100, 255);
rng.SetConditionalFormat(condFmt);
Code Block |
---|
{code}
{code:vb.net
vb.net | title | |title=vb.net
}
Dim xla As New ExcelApplication()
Dim wb As Workbook = xla.Create()
Dim rng As Range = wb.Worksheets(0).CreateRange("$B$2:$F$10")
Dim condFmt As ConditionalFormat = wb.CreateConditionalFormat()
Dim cond As Condition = _
condFmt.CreateCondition( _
Condition.Comparison.CellValueGreaterThan, _
"=100")
Dim fnt As Font = cond.Style.Font
fnt.Bold = True
fnt.Color = wb.Palette.GetClosestColor(100, 100, 255)
rng.SetConditionalFormat(condFmt)
{code}
{example}