ExcelSetConditionalFormat Method (IExcelBiffRead)
CONDFMT, CF - Excel Biff Records
bool ExcelSetConditionalFormat(
short ,
int[] ,
int[] ,
int[] ,
int[] ,
byte ,
IExcelXF ,
bool ,
FontStyle ,
int ,
int ,
byte[] ,
byte[]
)
'Declaration
Function ExcelSetConditionalFormat( _
ByVal As Short, _
ByVal () As Integer, _
ByVal () As Integer, _
ByVal () As Integer, _
ByVal () As Integer, _
ByVal As Byte, _
ByVal As IExcelXF, _
ByVal As Boolean, _
ByVal As FontStyle, _
ByVal As Integer, _
ByVal As Integer, _
ByVal () As Byte, _
ByVal () As Byte _
) As Boolean
'Usage
Dim instance As IExcelBiffRead
Dim sheet As Short
Dim firstRows() As Integer
Dim lastRows() As Integer
Dim firstCols() As Integer
Dim lastCols() As Integer
Dim comparisonOperator As Byte
Dim xf As IExcelXF
Dim isFontSet As Boolean
Dim fontStyle As FontStyle
Dim fontHeight As Integer
Dim patternStyle As Integer
Dim firstCondition() As Byte
Dim lastCondition() As Byte
Dim value As Boolean
value = instance.ExcelSetConditionalFormat(sheet, firstRows, lastRows, firstCols, lastCols, comparisonOperator, xf, isFontSet, fontStyle, fontHeight, patternStyle, firstCondition, lastCondition)
Parameters
- sheet
- Sheet index
- firstRows
- lastRows
- firstCols
- lastCols
- comparisonOperator
- xf
- isFontSet
- fontStyle
- fontHeight
- patternStyle
- firstCondition
- lastCondition