ConditionalFormat
Overview
ConditionalFormat is a class in Aspose.Cells FOSS for Python.
Represents a single conditional formatting rule applied to a cell range.
This class provides 1 method for working with ConditionalFormat objects in Python programs.
Available methods include: __init__.
All public members are accessible to any Python application after installing the Aspose.Cells FOSS for Python package.
Properties: above, alignment, bar_color, bar_length, border, color_scale_type, and 29 more.
Properties
| Name | Type | Access | Description |
|---|---|---|---|
type | `` | Read/Write | Gets or sets the conditional format type. |
range | `` | Read/Write | Gets or sets the cell range for the conditional format. |
stop_if_true | `` | Read/Write | Gets or sets whether to stop evaluating lower priority rules if this rule is true. |
priority | `` | Read/Write | Gets or sets the rule priority. |
operator | `` | Read/Write | Gets or sets the comparison operator for cell value rules. |
formula1 | `` | Read/Write | Gets or sets the first value/formula for comparison. |
formula2 | `` | Read/Write | Gets or sets the second value/formula for comparison. |
text_operator | `` | Read/Write | Gets or sets the text operator for text rules. |
text_formula | `` | Read/Write | Gets or sets the text value for comparison. |
date_operator | `` | Read/Write | Gets or sets the date operator for date rules. |
date_formula | `` | Read/Write | Gets or sets the optional date value for comparison. |
duplicate | `` | Read/Write | Gets or sets whether to highlight duplicate values. |
top | `` | Read/Write | Gets or sets whether to highlight top values. |
percent | `` | Read/Write | Gets or sets whether rank is a percentage. |
rank | `` | Read/Write | Gets or sets the rank value. |
above | `` | Read/Write | Gets or sets whether to highlight above average. |
std_dev | `` | Read/Write | Gets or sets the number of standard deviations. |
color_scale_type | `` | Read/Write | Gets or sets the color scale type. |
min_color | `` | Read/Write | Gets or sets the minimum value color for color scales. |
mid_color | `` | Read/Write | Gets or sets the midpoint color for 3-color scales. |
max_color | `` | Read/Write | Gets or sets the maximum value color for color scales. |
bar_color | `` | Read/Write | Gets or sets the bar color for data bars. |
negative_color | `` | Read/Write | Gets or sets the negative value color for data bars. |
show_border | `` | Read/Write | Gets or sets whether to show border for data bars. |
direction | `` | Read/Write | Gets or sets the bar direction for data bars. |
bar_length | `` | Read/Write | Gets or sets the bar length for data bars. |
icon_set_type | `` | Read/Write | Gets or sets the icon set type. |
reverse_icons | `` | Read/Write | Gets or sets whether to reverse icon order. |
show_icon_only | `` | Read/Write | Gets or sets whether to show only icons. |
formula | `` | Read/Write | Gets or sets the formula for formula-based rules. |
font | `` | Read | Gets the font settings for this conditional format. |
border | `` | Read | Gets the border settings for this conditional format. |
fill | `` | Read | Gets the fill settings for this conditional format. |
alignment | `` | Read | Gets the alignment settings for this conditional format. |
number_format | `` | Read/Write | Gets or sets the number format for this conditional format. |
Methods
| Signature | Description |
|---|---|
__init__() | Initializes a new instance of ConditionalFormat class. |