Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search

Skip to end of banner Go to start of banner

ConditionalFormat.CreateCondition(Condition.Comparison, String)

Skip to end of metadata

Created and last modified by Wiki Administrator on Aug 01, 2011

Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Description

Creates a Condition of the specified ComparisonType.

C#

vb.net

Parameters

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.CellValueLessThan, Condition.Comparison.CellValueGreaterThan, Condition.Comparison.CellValueLessThanOrEqualTo, Condition.Comparison.CellValueGreaterThanOrEqualTo, Condition.Comparison.CellValueEqualTo, or Condition.Comparison.CellValueNotEqualTo.

formula

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.

Examples

C#

vb.net

No labels