SetFormulaConditionalFormat(Int32,Int32,Int32,Int32,NamedStyle,String) Method
In This Topic
Sets a formula conditional format for the cell at the specified range.
Syntax
'Declaration
Public Overloads Function SetFormulaConditionalFormat( _
ByVal As Integer, _
ByVal column As Integer, _
ByVal As Integer, _
ByVal columnCount As Integer, _
ByVal As NamedStyle, _
ByVal As String _
) As Boolean
'Usage
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim style As NamedStyle
Dim formula As String
Dim value As Boolean
value = instance.SetFormulaConditionalFormat(row, column, rowCount, columnCount, style, formula)
public bool SetFormulaConditionalFormat(
int ,
int column,
int ,
int columnCount,
NamedStyle ,
string
)
Parameters
- row
- Starting row index
- column
- Starting column index
- rowCount
- Number of rows
- columnCount
- Number of columns
- style
- Style to be applied to the cell if the formula evaluates to true
- formula
- Formula for the condition
Return Value
Boolean:
true if successful;
false otherwise
See Also