Sets conditional formatting based on a specified formula for a specified cell.
Syntax
Visual Basic (Usage) | Copy Code |
---|
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim style As NamedStyle
Dim formula As String
Dim value As Boolean
value = instance.SetFormulaConditionalFormat(row, column, style, formula) |
Parameters
- row
- Row index of the cell
- column
- Column index of the cell
- style
- Style to be applied to the cell if the formula evaluates to true
- formula
- Formula to evaluate for the condition
Return Value
Boolean:
true if successful;
false otherwise
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also