Namespace DRIT.Spreadsheet.ConditionalFormatting

Classes

AboveAverageFormattingRule

Represents a conditional formatting rule that formats cells above or below the average value.

CellIsFormattingRule

Represents a conditional formatting rule that evaluates cell values.

ColorScaleCriteria

Represents one criteria in the color scale definition. It groups together the type, value with the color.

ConditionValue

Represents a condition value for color scale and icon set conditional formatting rules.

ConditionalFormatting

Represents a conditional formatting on a group of cells in a sheet.

ConditionalFormattingCollection

Represents the collection of conditional formattings on a worksheet.

ConditionalFormattingRule

Base class for all conditional formatting rules

ConditionalFormattingRuleCollection

Represents a collection of conditional formatting rules.

ContainsBlanksFormattingRule

Represents a conditional formatting rule that formats cells containing blank values.

ContainsErrorsFormattingRule

Represents a conditional formatting rule that formats cells containing error values.

ContainsNoBlanksFormattingRule

Represents a conditional formatting rule that formats cells not containing blank values.

ContainsNoErrorsFormattingRule

Represents a conditional formatting rule that formats cells not containing error values.

DataBarBorder

Represents the border settings for a data bar. Excel UI: "Conditional Formatting > Data Bars > More Rules > Border".

DataBarFormattingRule

Represents a conditional formatting rule that displays a data bar in cells.

DatesOccurringFormattingRule

Represents a conditional formatting rule that formats cells based on date occurrences.

DuplicateValuesFormattingRule

Represents a conditional formatting rule that formats duplicate cell values.

ExpressionFormattingRule

Represents a conditional formatting rule that evaluates a custom expression.

FormatFont

Font formatting to use with conditional formatting.

IconSet

Represents an icon set for conditional formatting.

IconSetFormattingRule

Represents a conditional formatting rule that displays icons based on cell values.

IconSetInformation

Provides information about icon set conditional formatting for a specific cell value.

NegativeBarFormat

Represents the formatting for negative values in a data bar. Excel UI: "Conditional Formatting > Data Bars > More Rules > Negative Bar".

SpecificTextFormattingRule

Represents a conditional formatting rule that formats cells based on specific text criteria.

StandardConditionalFormattingRule

Base class for standard conditional formatting rules that support style formatting.

ThreeColorScaleFormattingRule

Represents a conditional formatting rule that displays a three-color scale in cells.

Top10FormattingRule

Represents a conditional formatting rule that formats the top or bottom ranked cells.

TwoColorScaleFormattingRule

Represents a conditional formatting rule that displays a two-color scale in cells.

UniqueValuesFormattingRule

Represents a conditional formatting rule that formats unique cell values.

Enums

ConditionValueType

Specifies the type of condition value for color scale and icon set conditional formatting.

ConditionalFormattingOperator

Specifies the comparison operator for conditional formatting rules.

ConditionalFormattingType

Specifies the type of conditional formatting rule.

DataBarAxisPosition

Specifies the axis position for a data bar. Excel UI: "Conditional Formatting > Data Bars > More Rules > Negative Values and Axis".

DataBarBorderType

Specifies the border type for a data bar. Excel UI: "Conditional Formatting > Data Bars > More Rules > Border".

DataBarDirection

Specifies the direction of a data bar. Excel UI: "Conditional Formatting > Data Bars > More Rules > Bar Direction".

DataBarFillType

Specifies the fill type for a data bar. Excel UI: "Conditional Formatting > Data Bars > More Rules > Fill".

DataBarNegativeColorType

Specifies how the negative bar color is determined for a data bar. Excel UI: "Conditional Formatting > Data Bars > More Rules > Negative Bar".

IconSetType

Specifies the type of icon set for conditional formatting.

SpecificTextFormattingRuleType

Specifies the type of specific text conditional formatting rule.

TimePeriod

Specifies time periods for date-based conditional formatting rules.