IConditionalFormat Interface

Represents conditional format associated with a range of cells.

Namespace: MindFusion.Spreadsheet.Wpf
Assembly: MindFusion.Spreadsheet.Wpf

 Syntax

C#

public interface IConditionalFormat

Visual Basic

Public Interface IConditionalFormat

 Remarks

This interface can be used to customize the appearance of a cell or a range of cells based on a condition. There are two types of conditions that can be used - a cell value comparison or an expression. The type of the condition is specified through the Type property. When the condition is satisfied the style specified by Style is applied to the associated cell or range of cells.

Cell Value Comparison

The first condition type compares the value of the associated cell to the values specified by First and Second using the operator specified by Operator. The following table illustrates how the two operands are used by each operator.

Operator	Condition
Between	The cell value must be greater than or equal to First and less than or equal to Second. The cell value should be numeric, and the operands must be convertible to numbers.
NotBetween	The cell value must be less than First or greater than Second. The cell value should be numeric and the operands must be convertible to numbers.
Equal / NotEqual	The cell value must be equal / not equal to First. Second is not used. If cell value is a numeric, First must be convertible to number. If cell value is a string, First must be convertible to string.
LessThan / LessThanOrEqual	The cell value must be less than / less than or equal to First. Second is not used. The cell value should be numeric and the operand must be convertible to number.
GreaterThan / GreaterThanOrEqual	The cell value must be greater than / greater than or equal to Second. First is not used. The cell value should be numeric and the operand must be convertible to number.
Contain / NotContain	The cell value should contain the value of First. Second is not used. The cell value should be string and the operand must be convertible to string.

Expression

The second condition type checks the result of an expression. The expression is specified by the First operand. The condition is satisfied when the expression evaluates to true.