IConditionalFormat Interface |
Contains a condition and the formatting attributes applied
to the cells, if the condition is met.
Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
The IConditionalFormat type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
|
BackColor |
Pattern background color.
|
|
|
BackKnownColor |
Pattern background color.
|
|
|
BottomBorderColor |
Color of the bottom line
|
|
|
BottomBorderKnownColor |
Color of the bottom line.
|
|
|
BottomBorderStyle |
Bottom border line style.
|
|
|
Color |
Pattern foreground color.
|
|
|
ColorScale |
Returns color scale settings. Valid only if FormatType is set to ColorScale. Read-only.
|
|
|
DataBar |
Returns data bar settings. Valid only if FormatType is set to DataBar. Read-only.
|
|
|
FillPattern |
XlsFill pattern style.
|
|
|
FirstFormula |
First formula.
|
|
|
FontColor |
Font color.
|
|
|
FontKnownColor |
Font color.
|
|
|
FormatType |
Type of the conditional format.
|
|
|
IconSet |
Returns iconset settings. Valid only if FormatType is set to IconSet. Read-only.
|
|
|
IsBold |
Indicates whether the font is bold.
|
|
|
IsItalic |
Indicates whether font is italic.
|
|
|
IsStrikeThrough |
Indicates whether font is struck through.
|
|
|
IsSubScript |
Indicates whether font is subscript.
|
|
|
IsSuperScript |
Indicates whether font is superscript.
|
|
|
KnownColor |
Pattern foreground color.
|
|
|
LeftBorderColor |
Color of the left line.
|
|
|
LeftBorderKnownColor |
Color of the left line.
|
|
|
LeftBorderStyle |
Left border line style.
|
|
|
Operator |
Type of the comparison operator.
|
|
|
Parent |
Gets the parent object of the current instance.
(Inherited from
IExcelApplication
.)
|
|
|
Priority |
Priority.
|
|
|
RightBorderColor |
Color of the right line.
|
|
|
RightBorderKnownColor |
Color of the right line.
|
|
|
RightBorderStyle |
Right border line style.
|
|
|
SecondFormula |
Second formula.
|
|
|
TopBorderColor |
Color of the top line.
|
|
|
TopBorderKnownColor |
Color of the top line.
|
|
|
TopBorderStyle |
Top border line style.
|
|
|
Underline |
Underline type.
|
See Also
