Namespace Telerik.Windows.Documents.Spreadsheet.Model.ConditionalFormattings

Classes

AutomaticMaximumValue Specifies an automatic maximum threshold that resolves to the highest value in the conditional formatting range.

AutomaticMinimumValue Specifies an automatic minimum threshold that resolves to the lowest value in the conditional formatting range.

BeginsWithRule Conditional formatting rule that applies formatting when a cell's text value begins with a specified text string.

BetweenRule Conditional formatting rule that applies formatting when a cell value falls between two specified bounds, inclusive.

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

ColorScaleRule Applies gradient color formatting to cells based on their numeric distance between minimum and maximum values, creating a visual heatmap effect.

ColorScaleValueContextBase Abstract base for color scale value contexts that define minimum and maximum values with associated colors for gradient conditional formatting.

ConditionalFormatting Conditional formatting applied to one or more cell ranges, dynamically styling cells based on a formatting rule.

ConditionalFormattingDxfRule Base class for conditional formatting rules that apply differential formatting (overlay properties) when conditions are met, providing visual feedback without replacing base cell formatting.

ConditionalFormattingRange Associates a cell range with the conditional formatting rules applied to it, enabling retrieval of all active formatting conditions for a specific region.

ConditionalFormattingResult Holds the evaluation result of a conditional formatting rule over a cell range, determining whether the formatting should be applied.

ConditionalFormattingRule Base class for rules that evaluate cell values and apply formatting when specific conditions are met, enabling dynamic visual feedback in worksheets.

ContainsBlanksRule Conditional formatting rule that applies formatting when a cell is blank or contains only whitespace.

ContainsRule Conditional formatting rule that applies formatting when a cell's text value contains a specified substring.

DataBarRule Renders horizontal data bars within cells based on their numeric values relative to the range minimum and maximum, with customizable colors, gradients, and axis positioning.

DataBarValueContext Defines the minimum and maximum value thresholds for calculating data bar lengths in conditional formatting.

DifferentialFormatting Defines formatting properties that overlay base cell formatting when conditional formatting rules are met, allowing selective property changes without replacing all formatting.

DoubleArgumentConditionalFormattingRule Base class for conditional formatting rules that require two comparison arguments, supporting both literal values and formula expressions for flexible condition evaluation.

DuplicateValuesRule Conditional formatting rule that applies formatting to cells containing values that appear more than once in the rule's range.

EndsWithRule Conditional formatting rule that applies formatting when a cell's text value ends with a specified text string.

EqualToRule Conditional formatting rule that applies formatting when a cell value equals a specified argument value.

FiveIconSetValueContext Defines five value range thresholds and their associated icons for classifying cell values in icon set conditional formatting.

FormulaRule Conditional formatting rule that applies formatting when a cell satisfies a custom formula expression.

FormulaValue Specifies a threshold value calculated dynamically from a formula expression for conditional formatting rules.

FourIconSetValueContext Configures icon set conditional formatting with four threshold ranges, assigning distinct icons to cells based on which range their value falls into.

GreaterThanOrEqualToRule Conditional formatting rule that applies formatting when a cell value is greater than or equal to a specified argument value.

GreaterThanRule Conditional formatting rule that applies formatting when a cell value is greater than a specified argument value.

HasErrorRule Conditional formatting rule that applies formatting when a cell contains an error value such as #DIV/0!, #N/A, or #VALUE!.

HasNoErrorRule Conditional formatting rule that applies formatting when a cell does not contain an error value such as #DIV/0!, #N/A, or #VALUE!.

IconDefinition Identifies a specific icon within a preset icon set by combining the set type and the icon's index position, used in icon set conditional formatting.

IconSetRange Defines a threshold boundary for icon set conditional formatting, combining a comparison operator with a threshold value to determine icon assignment.

IconSetRule Displays icons in cells based on numeric value thresholds, categorizing data into 3, 4, or 5 ranges with distinct visual indicators.

IconSetValueContextBase Base class for icon set conditional formatting contexts, managing threshold ranges and icon resolution for cell values.

LessThanOrEqualToRule Conditional formatting rule that applies formatting when a cell value is less than or equal to a specified argument value.

LessThanRule Conditional formatting rule that applies formatting when a cell value is less than a specified argument value.

MaximumValue Specifies the highest value in the applied range for use in conditional formatting rules.

MinimumValue Specifies the lowest value in the applied range for use in conditional formatting rules.

NotBetweenRule Conditional formatting rule that applies formatting when a cell value falls outside the range defined by two specified bounds.

NotContainsBlanksRule Conditional formatting rule that applies formatting when a cell is not blank and contains non-whitespace content.

NotContainsRule Conditional formatting rule that applies formatting when a cell's text value does not contain a specified substring.

NotEqualToRule Conditional formatting rule that applies formatting when a cell value does not equal a specified argument value.

NumericValue Specifies a fixed numeric threshold for conditional formatting rules.

PercentileValue Specifies a percentile-based threshold for conditional formatting, where the value is determined by the specified percentile within the range.

PercentValue Specifies a percentage-based threshold for conditional formatting, where the value is calculated as a percentage of the range span.

RangeValueContextBase Base class for conditional formatting contexts that apply visual formatting based on value ranges across cells.

SingleArgumentComparisonRule Base class for conditional formatting rules that compare cell values against a single argument, supporting both absolute values and formula-based arguments.

SingleArgumentConditionalFormattingRule Abstract base for conditional formatting rules that evaluate a single argument, supporting both absolute values and formula expressions.

ThreeColorScaleValueContext Defines a three-color gradient scale with minimum, midpoint, and maximum value thresholds and their associated colors for conditional formatting.

ThreeIconSetValueContext Configures icon set conditional formatting with three threshold ranges, assigning distinct icons to cells based on which range their value falls into.

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

TwoColorScaleValueContext Defines a two-color gradient scale with minimum and maximum value thresholds and their associated colors for conditional formatting.

UniqueValuesRule Conditional formatting rule that applies formatting to cells containing values that appear exactly once in the rule's range.

ValueDistributionRule Applies differential formatting to cells based on their position relative to the average of a range, supporting above, below, and equal-to-average conditions.

Interfaces

IAbsoluteRangeValue Defines a fixed numeric threshold value for conditional formatting range calculations.

IRangeValue Defines a value that can be assigned to range-based conditional formatting rules such as data bars, color scales, and icon sets.

Enums

ConditionalFormattingUnit Specifies whether a conditional formatting rule's rank value is interpreted as item count or percentage.

DataBarAxisPosition Specifies where the axis is positioned in data bar conditional formatting, affecting how positive and negative values are displayed.

DataBarDirection Specifies the direction in which data bars extend within cells for conditional formatting visualization.

IconSetRangeOperator Specifies comparison operators for evaluating icon set threshold ranges.

OccurrenceTimePeriod Specifies time periods for conditional formatting rules that compare dates against relative time ranges.

PresetIconSet Specifies the built-in icon sets available for icon set conditional formatting, each containing 3-5 related icons for visualizing data ranges.

ValueDistribution Specifies how cell values compare to the average value in a range for conditional formatting rules.

ValueType Specifies how a threshold value is calculated or interpreted in range-based conditional formatting rules.