TConditionalCellIsRule Class

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

Syntax

Namespace: FlexCel.Core

public class TConditionalCellIsRule: TConditionalFormatStandardDefRule

Constructors

Name	Description
TConditional​Cell​IsRule	Creates a new instance of TConditional​Cell​IsRule.​

Methods

Name	Description
Equals	Returns true if this object is equal to obj.
GetHashCode	Returns the hashcode for this object.

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.