Spread WPF 18
GrapeCity.Spreadsheet Namespace / IFormatCondition Interface
Properties Methods

In This Topic
    IFormatCondition Interface Members
    In This Topic

    The following tables list the members exposed by IFormatCondition.

    Public Properties
     NameDescription
    PropertyAppliesToReturns a IRange object specifying the cell range to which the formatting rule is applied.  
    PropertyBordersReturns a IBorders collection that represents the borders of a style or a range of cells (including a range defined as part of a conditional format).  
    PropertyDateOperatorGets or sets the date operator used in the format condition.  
    PropertyFontReturns a IFont object that represents the font of the specified object.  
    PropertyFormula1Returns the value or expression associated with the conditional format or data validation. Can be a constant value, a string value, a cell reference, or a formula.  
    PropertyFormula2Returns the value or expression associated with the second part of a conditional format or data validation.  
    PropertyInteriorReturns an IInterior object that represents the interior of the specified object.  
    PropertyNumberFormatGets or sets the number format applied to a cell if the conditional formatting rule evaluates to true.  
    PropertyOperatorReturns a FormatConditionOperator value that represents the operator for the conditional format.  
    PropertyPriorityGets or sets the priority value of the conditional formatting rule. The priority determines the order of evaluation when multiple conditional formatting rules exist in a worksheet.  
    PropertyStopIfTrueGets or sets a System.Boolean value that determines if additional formatting rules on the cell should be evaluated if the current rule evaluates to true.  
    PropertyTextGets or sets a System.String value specifying the text string used by the conditional formatting rule.  
    PropertyTextOperatorGets or sets one of the constants of the ContainsOperator enumeration, specifying the text search performed by the conditional formatting rule.  
    PropertyTypeGets a FormatConditionType value that represents the format condition type.  
    Top
    Public Methods
     NameDescription
    MethodDeleteDeletes this conditional format.  
    MethodModifyOverloaded. Modifies an existing conditional format.  
    MethodModifyAppliesToRangeOverloaded. Modifies an existing text conditional format.  
    MethodSetFirstPrioritySets the priority value for this conditional formatting rule to "1" so that it will be evaluated before all other rules on the worksheet.  
    MethodSetLastPrioritySets the evaluation order for this conditional formatting rule so it is evaluated after all other rules on the worksheet.  
    Top
    See Also

    Reference

    IFormatCondition Interface
    GrapeCity.Spreadsheet Namespace