Skip to main content

Module conditional

Module conditional 

Source
Expand description

Conditional formatting builder and utilities.

Provides a high-level API for adding, querying, and removing conditional formatting rules on worksheet cells. Supports cell-is comparisons, formula-based rules, color scales, data bars, duplicate/unique values, top/bottom N, above/below average, and text-based rules.

Structs§

ConditionalFormatRule
A single conditional formatting rule with its style.
ConditionalStyle
Style applied by a conditional formatting rule.

Enums§

CfOperator
Comparison operator for CellIs conditional formatting rules.
CfValueType
Value type for color scale and data bar thresholds.
ConditionalFormatType
The type of conditional formatting rule.

Functions§

delete_conditional_format
Delete all conditional formatting rules for a specific cell range.
get_conditional_formats
Get all conditional formatting rules from a worksheet.
set_conditional_format
Set conditional formatting rules on a cell range. Each call adds a new conditionalFormatting element with one or more cfRule children.