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 |
---|---|
TConditionalCellIsRule | Creates a new instance of TConditionalCellIsRule. |
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. |