Page tree
    Created with Raphaël 2.1.0
    Loading...
Skip to end of metadata
Go to start of metadata

Description

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.
C#
public Comparison ComparisonType{ get; }
vb.net
Public ReadOnly Property ComparisonType() As Comparison

Examples

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;
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
  • No labels