Class ConditionalFormattingRule

Represents a description of a conditional formatting rule.

Inheritance

System.Object

ConditionalFormattingRule

Namespace: IronXL.Formatting

Assembly: IronXL.dll

Syntax

public class ConditionalFormattingRule : Object

Properties

BorderFormatting

Gets the border formatting.

Declaration

public IBorderFormatting BorderFormatting { get; }

Property Value

Type	Description
IBorderFormatting	The border formatting.

ComparisonOperation

The comparison function used when the type of conditional formatting is Set to CellValueIs

Declaration

public ComparisonOperator ComparisonOperation { get; }

Property Value

Type	Description
ComparisonOperator	The conditional format operator.

ConditionType

Type of conditional formatting rule. MUST be either CellValueIs or NPOI.SS.Formula.Formula

Declaration

public ConditionType ConditionType { get; }

Property Value

Type	Description
ConditionType	The type of condition.

FontFormatting

Gets the font formatting.

Declaration

public IFontFormatting FontFormatting { get; }

Property Value

Type	Description
IFontFormatting	The font formatting.

Formula1

The formula used to Evaluate the first operand for the conditional formatting rule.

If the condition type is CellValueIs this field is the first operand of the comparison. If type is NPOI.SS.Formula.Formula, this formula is used to determine if the conditional formatting is applied.

If comparison type is NPOI.SS.Formula.Formula the formula MUST be a Boolean function

Declaration

public string Formula1 { get; }

Property Value

Type	Description
System.String	The first formula of the rule

Formula2

The formula used to Evaluate the second operand of the comparison when condition type is CellValueIs and operator is either Between or NotBetween

Declaration

public string Formula2 { get; }

Property Value

Type	Description
System.String	The second formula of the rule.

PatternFormatting

Gets the pattern formatting.

Declaration

public IPatternFormatting PatternFormatting { get; }

Property Value

Type	Description
IPatternFormatting	The pattern formatting.