ConditionalFormatting Method

In This Topic

Shows the conditional formatting dialog to manage all conditional formatting rules in the workbook.

Syntax

Visual Basic
C#

'Declaration
 
Public Shared Function ConditionalFormatting( _
   ByVal spread As GcSpreadSheet, _
   Optional ByVal createRule As Boolean, _
   Optional ByVal formatcoditionalType As FormatConditionType, _
   Optional ByVal cellValueOperator As FormatConditionOperator, _
   Optional ByVal isPercent As Boolean, _
   Optional ByVal topBottom As TopBottom, _
   Optional ByVal isAbove As Boolean, _
   Optional ByVal selectedRuleCategory As Integer, _
   Optional ByVal formatStyleIndex As Integer _
) As IDialog

'Usage
 
Dim spread As GcSpreadSheet
Dim createRule As Boolean
Dim formatcoditionalType As FormatConditionType
Dim cellValueOperator As FormatConditionOperator
Dim isPercent As Boolean
Dim topBottom As TopBottom
Dim isAbove As Boolean
Dim selectedRuleCategory As Integer
Dim formatStyleIndex As Integer
Dim value As IDialog
 
value = BuiltInDialogs.ConditionalFormatting(spread, createRule, formatcoditionalType, cellValueOperator, isPercent, topBottom, isAbove, selectedRuleCategory, formatStyleIndex)

public static IDialog ConditionalFormatting( 
   GcSpreadSheet spread,
   bool createRule,
   FormatConditionType formatcoditionalType,
   FormatConditionOperator cellValueOperator,
   bool isPercent,
   TopBottom topBottom,
   bool isAbove,
   int selectedRuleCategory,
   int formatStyleIndex
)

Parameters

spread: The GrapeCity.Wpf.SpreadSheet.GcSpreadSheet control to work with.
createRule: true to show the creating conditional formatting rule dialog.
formatcoditionalType
cellValueOperator
isPercent
topBottom
isAbove
selectedRuleCategory
formatStyleIndex

Return Value

The IDialog object represents the format cells dialog.

Reference

BuiltInDialogs Class
BuiltInDialogs Members