Document Solutions for Excel, .NET Edition | Document Solutions
GrapeCity.Documents.Excel 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 the IRange object that specifies the cell range to which the formatting rule is applied.  
    PropertyBorders Returns an instance of IBorders which represents the borders of this conditional format.  
    PropertyDateOperatorGets or sets the TimePeriods Date operator used in the format condition (read or write).  
    PropertyFontReturns an instance of IFont which represents the font of this conditional format.  
    PropertyFormula1 Returns the first formula of this conditional format.  
    PropertyFormula2 Returns the second formula of this conditional format.  
    PropertyInteriorReturns an instance of IInterior which represents the background color of this conditional format.  
    PropertyNumberFormat Returns or sets the number format applied to a cell if the conditional formatting rule evaluates to True (read or write object).  
    PropertyOperator Returns the operator of this conditional format.  
    PropertyPriority Returns 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.  
    PropertyStopIfTrue Returns or sets a Boolean value that determines if additional formatting rules on the cell should be evaluated if the current rule evaluates to True.  
    PropertyText Returns or sets a String value specifying the text used by the conditional formatting rule.  
    PropertyTextOperatorReturns or sets one of the constants of the ContainsOperator enumeration, specifying the text search performed by the conditional formatting rule.  
    PropertyType Returns the type of this conditional format.  
    Top
    Public Methods
     NameDescription
    MethodDelete Deletes this conditional format.  
    MethodFromJson Generates the conditional format from the json string.  
    MethodSetFirstPriority Sets the priority value for this conditional formatting rule to "1" so that it will be evaluated before all other rules on the worksheet.  
    MethodSetLastPriority Sets the evaluation order for this conditional formatting rule so it is evaluated after all other rules on the worksheet.  
    MethodToJson Generates a json string from the conditional format.  
    Top
    See Also

    Reference

    IFormatCondition Interface
    GrapeCity.Documents.Excel Namespace