Class
TopRule

Conditional formatting rule that applies formatting to cells containing the largest values in a range, by rank or percentage.

Definition

Constructors

TopRule(ConditionalFormattingUnit, int)

Initializes a new TopRule with the specified unit type and rank count.

Declaration

cs-api-definition
[Obsolete("This constructor is obsoleted, please use the one with formatting parameter instead.")]
public TopRule(ConditionalFormattingUnit unit, int rank)

Parameters

unit

ConditionalFormattingUnit

rank

int

TopRule(ConditionalFormattingUnit, int, DifferentialFormatting)

Initializes a new TopRule with the specified unit type, rank count, and formatting to apply when the condition is met.

Declaration

cs-api-definition
public TopRule(ConditionalFormattingUnit unit, int rank, DifferentialFormatting formatting)

Parameters

unit

ConditionalFormattingUnit

rank

int

formatting

DifferentialFormatting

Properties

Rank

Specifies the number or percentage of top values to format, depending on the unit type.

Declaration

cs-api-definition
public int Rank { get; set; }

Property Value

int

Unit

Specifies whether the rank is interpreted as item count or percentage.

Declaration

cs-api-definition
public ConditionalFormattingUnit Unit { get; set; }

Property Value

ConditionalFormattingUnit