IConditionalCellIsRule Interface

A conditional format rule specified by the value on a cell (less than, equal, etc).

Syntax

Unit: FlexCel.Core

IConditionalCellIsRule = interface(IConditionalFormatStandardDefRule);

Properties

Name	Description
ConditionType	Condition to apply for the rule.
Formula1	The first formula to be evaluated. When the condition needs only one parameter (for example when condition is "Equal") this is the only formula that is used. Note that with relative references, we always consider "A1" to be the cell where the format is. This means that the formula: "=$A$1 + A1" when evaluated in Cell B8, will read "=$A$1 + B8". To provide a negative offset, you need to wrap the formula. For example "=A1048575" will evaluate to B7 when evaluated in B8.
Formula2	The second formula to be evaluated. Note that this formula is only used if the condition needs more than one parameter (for example when condition is "Between"). If using a condition with only one parameter, you can leave this formula to null. Note that with relative references, we always consider "A1" to be the cell where the format is. This means that the formula: "=$A$1 + A1" when evaluated in Cell B8, will read "=$A$1 + B8". To provide a negative offset, you need to wrap the formula. For example "=A1048575" will evaluate to B7 when evaluated in B8.