Telerik.Windows.Documents.Spreadsheet.Model.ConditionalFormattings
Specifies an automatic maximum threshold that resolves to the highest value in the conditional formatting range.
Specifies an automatic minimum threshold that resolves to the lowest value in the conditional formatting range.
Conditional formatting rule that applies formatting when a cell's text value begins with a specified text string.
Conditional formatting rule that applies formatting when a cell value falls between two specified bounds, inclusive.
Conditional formatting rule that applies formatting to cells containing the smallest values in a range, by rank or percentage.
Applies gradient color formatting to cells based on their numeric distance between minimum and maximum values, creating a visual heatmap effect.
Abstract base for color scale value contexts that define minimum and maximum values with associated colors for gradient conditional formatting.
Conditional formatting applied to one or more cell ranges, dynamically styling cells based on a formatting rule.
Base class for conditional formatting rules that apply differential formatting (overlay properties) when conditions are met, providing visual feedback without replacing base cell formatting.
Associates a cell range with the conditional formatting rules applied to it, enabling retrieval of all active formatting conditions for a specific region.
Holds the evaluation result of a conditional formatting rule over a cell range, determining whether the formatting should be applied.
Base class for rules that evaluate cell values and apply formatting when specific conditions are met, enabling dynamic visual feedback in worksheets.
Specifies whether a conditional formatting rule's rank value is interpreted as item count or percentage.
Conditional formatting rule that applies formatting when a cell is blank or contains only whitespace.
Conditional formatting rule that applies formatting when a cell's text value contains a specified substring.
Specifies where the axis is positioned in data bar conditional formatting, affecting how positive and negative values are displayed.
Specifies the direction in which data bars extend within cells for conditional formatting visualization.
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.
Defines the minimum and maximum value thresholds for calculating data bar lengths in conditional formatting.
Defines formatting properties that overlay base cell formatting when conditional formatting rules are met, allowing selective property changes without replacing all formatting.
Base class for conditional formatting rules that require two comparison arguments, supporting both literal values and formula expressions for flexible condition evaluation.
Conditional formatting rule that applies formatting to cells containing values that appear more than once in the rule's range.
Conditional formatting rule that applies formatting when a cell's text value ends with a specified text string.
Conditional formatting rule that applies formatting when a cell value equals a specified argument value.
Defines five value range thresholds and their associated icons for classifying cell values in icon set conditional formatting.
Conditional formatting rule that applies formatting when a cell satisfies a custom formula expression.
Specifies a threshold value calculated dynamically from a formula expression for conditional formatting rules.
Configures icon set conditional formatting with four threshold ranges, assigning distinct icons to cells based on which range their value falls into.
Conditional formatting rule that applies formatting when a cell value is greater than or equal to a specified argument value.
Conditional formatting rule that applies formatting when a cell value is greater than a specified argument value.
Conditional formatting rule that applies formatting when a cell contains an error value such as #DIV/0!, #N/A, or #VALUE!.
Conditional formatting rule that applies formatting when a cell does not contain an error value such as #DIV/0!, #N/A, or #VALUE!.
Defines a fixed numeric threshold value for conditional formatting range calculations.
Defines a value that can be assigned to range-based conditional formatting rules such as data bars, color scales, and icon sets.
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.
Defines a threshold boundary for icon set conditional formatting, combining a comparison operator with a threshold value to determine icon assignment.
Specifies comparison operators for evaluating icon set threshold ranges.
Displays icons in cells based on numeric value thresholds, categorizing data into 3, 4, or 5 ranges with distinct visual indicators.
Base class for icon set conditional formatting contexts, managing threshold ranges and icon resolution for cell values.
Conditional formatting rule that applies formatting when a cell value is less than or equal to a specified argument value.
Conditional formatting rule that applies formatting when a cell value is less than a specified argument value.
Specifies the highest value in the applied range for use in conditional formatting rules.
Specifies the lowest value in the applied range for use in conditional formatting rules.
Conditional formatting rule that applies formatting when a cell value falls outside the range defined by two specified bounds.
Conditional formatting rule that applies formatting when a cell is not blank and contains non-whitespace content.
Conditional formatting rule that applies formatting when a cell's text value does not contain a specified substring.
Conditional formatting rule that applies formatting when a cell value does not equal a specified argument value.
Specifies a fixed numeric threshold for conditional formatting rules.
Specifies time periods for conditional formatting rules that compare dates against relative time ranges.
Specifies a percentage-based threshold for conditional formatting, where the value is calculated as a percentage of the range span.
Specifies a percentile-based threshold for conditional formatting, where the value is determined by the specified percentile within the range.
Specifies the built-in icon sets available for icon set conditional formatting, each containing 3-5 related icons for visualizing data ranges.
Base class for conditional formatting contexts that apply visual formatting based on value ranges across cells.
Base class for conditional formatting rules that compare cell values against a single argument, supporting both absolute values and formula-based arguments.
Abstract base for conditional formatting rules that evaluate a single argument, supporting both absolute values and formula expressions.
Defines a three-color gradient scale with minimum, midpoint, and maximum value thresholds and their associated colors for conditional formatting.
Configures icon set conditional formatting with three threshold ranges, assigning distinct icons to cells based on which range their value falls into.
Conditional formatting rule that applies formatting to cells containing the largest values in a range, by rank or percentage.
Defines a two-color gradient scale with minimum and maximum value thresholds and their associated colors for conditional formatting.
Conditional formatting rule that applies formatting to cells containing values that appear exactly once in the rule's range.
Specifies how cell values compare to the average value in a range for conditional formatting rules.
Applies differential formatting to cells based on their position relative to the average of a range, supporting above, below, and equal-to-average conditions.
Specifies how a threshold value is calculated or interpreted in range-based conditional formatting rules.