Table of Contents

Interface IExcelConditionalFormattingRule

Namespace
OfficeOpenXml.ConditionalFormatting.Contracts
Assembly
EPPlus.dll

Interface for conditional formatting rule

public interface IExcelConditionalFormattingRule

Properties

Address

The range over which these conditional formatting rules apply.

ExcelAddress Address { get; set; }

Property Value

ExcelAddress

As

Type case propterty for the base class.

ExcelConditionalFormattingAsType As { get; }

Property Value

ExcelConditionalFormattingAsType

PivotTable

Indicates that the conditional formatting is associated with a PivotTable

bool PivotTable { get; set; }

Property Value

bool

Priority

The priority of the rule. Priority for the rule gets lower the higher this number is. 1 is the highest priority.

int Priority { get; set; }

Property Value

int

StopIfTrue

If this property is true, no rules with lower priority should be applied over this rule.

bool StopIfTrue { get; set; }

Property Value

bool

Style

Gives access to the differencial styling (DXF) for the rule.

ExcelDxfStyleConditionalFormatting Style { get; }

Property Value

ExcelDxfStyleConditionalFormatting

Type

The type of conditional formatting rule.

eExcelConditionalFormattingRuleType Type { get; }

Property Value

eExcelConditionalFormattingRuleType