Page History

Description

Excerpt
Returns the Condition's Condition.Comparison value, which determines whether each cell value will be compared with one or two other values, or if a formula will be evaluated for each cell.

Signature

	C#
	C#

<table class="diff-macro"><thead><tr><th class="diff-macro-title">unmigrated-wiki-markup</th></tr></thead><tbody><tr><td class="diff-macro-body"><pre>
 public Comparison ComparisonType{ get; }
</pre></td></tr></tbody></table>

Signature

	vb.net
	vb.net

Public <p>Public ReadOnly Property ComparisonType() As Comparison</p>Comparison

Example

Code Block

	csharp
	csharp
title	C#

            ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          ConditionalFormat condFmt = wb.CreateConditionalFormat();
          Condition cond =
               condFmt.CreateCondition(
               Condition.Comparison.CellValueGreaterThan,
               "=100");
          Condition.Comparison compType = cond.ComparisonType;

Code Block

	vb.net
	vb.net
title	vb.net

            Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          Dim condFmt As ConditionalFormat = wb.CreateConditionalFormat()
          Dim cond As Condition = _
               condFmt.CreateCondition( _
               Condition.Comparison.CellValueGreaterThan, _
               "=100")
          Dim compType As Condition.Comparison = cond.ComparisonType

Space Shortcuts

Page tree

Versions Compared

Old Version 45

New Version Current

Key