Module xlsxwriter::worksheet::conditional_format

Conditional Format.

Supported criteria.

• ConditionalFormat::average
• ConditionalFormat::blanks
• ConditionalFormat::no_blanks
• ConditionalFormat::errors
• ConditionalFormat::no_errors
• ConditionalFormat::formula
• ConditionalFormat::duplicate
• ConditionalFormat::unique
• ConditionalFormat::top_num
• ConditionalFormat::top_percent
• ConditionalFormat::cell_between
• ConditionalFormat::cell_not_between
• ConditionalFormat::cell_equal_to
• ConditionalFormat::cell_not_equal_to
• ConditionalFormat::cell_greater_than
• ConditionalFormat::cell_greater_than_or_equal_to
• ConditionalFormat::cell_less_than
• ConditionalFormat::cell_less_than_or_equal_to
• ConditionalFormat::text_begins_with
• ConditionalFormat::text_ends_with
• ConditionalFormat::text_containing
• ConditionalFormat::text_not_containing
• ConditionalFormat::time_period
• ConditionalFormat::two_color_scale
• ConditionalFormat::three_color_scale
• ConditionalFormat::data_bar
• ConditionalFormat::icon_set

Structs

• ConditionalDataBar
  The Data Bar type is used to specify Excel’s “Data Bar” style conditional format.
• ConditionalIconSet
  The Icon Set type is used to specify a conditional format with a set of icons such as traffic lights or arrows.
• ThreeColorScaleCriteria
  The 3 Color Scale type is used to specify Excel’s “3 Color Scale” style conditional format.
• TwoColorScaleCriteria
  The 2 Color Scale type is used to specify Excel’s “2 Color Scale” style conditional format.

Enums

• ConditionalBarAxisPosition
  Values used to set the position of the axis in a conditional format data bar.
• ConditionalFormat
  Conditional Format Criteria and Format.
• ConditionalFormatAverageCriteria
  The Average type is used to specify Excel’s “Average” style conditional format.
• ConditionalFormatBarDirection
  Values used to set the bar direction of a conditional format data bar.
• ConditionalFormatCellCriteria
  The Cell type is the most common conditional formatting type. It is used when a format is applied to a cell based on a simple criterion.
• ConditionalFormatRuleTypes
  Conditional format rule types that apply to Color Scale and Data Bars.
• ConditionalFormatTextCriteria
  The Text type is used to specify Excel’s “Specific Text” style conditional format.
• ConditionalFormatTimePeriodCriteria
  The Time Period type is used to specify Excel’s “Dates Occurring” style conditional format.
• ConditionalFormatTypes
  See ConditionalFormat to learn more
• ConditionalIconType
  Definitions of icon styles used with Icon Set conditional formats.
• TopOrBottomCriteria
  The Top or bottom type is used to specify the top n values by number or percentage in a range.