Search Results for

    Show / Hide Table of Contents

    TConditionalExpressionRule Class

    A conditional format rule specified by a formula.

    Syntax

    Namespace: FlexCel.Core

    public class TConditionalExpressionRule: TConditionalFormatStandardDefRule

    Constructors

    Name Description
    TConditional​Expression​Rule Creates a new instance of TConditional​Expression​Rule.​

    Methods

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

    Properties

    Name Description
    Formula The formula to be evaluated. The conditional format will be applied when it evaluates to true.

    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.


    In Icon sets, Data bars and Color Scales, the formula specifies if the conditional format is applied or not.
    This is not an option in the Excel UI, but you can specify it in the file and Excel will obey it.

    ...[more]
    In This Article
    Back to top FlexCel Studio for the .NET Framework v7.24.0.0
    © 2002 - 2025 tmssoftware.com