Class
BottomRule

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

Definition

Constructors

BottomRule(ConditionalFormattingUnit, int)

Initializes a new BottomRule 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 BottomRule(ConditionalFormattingUnit unit, int rank)

Parameters

unit

ConditionalFormattingUnit

rank

int

BottomRule(ConditionalFormattingUnit, int, DifferentialFormatting)

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

Declaration

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

Parameters

unit

ConditionalFormattingUnit

rank

int

formatting

DifferentialFormatting

Properties

Rank

Specifies the number or percentage of bottom 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