GrapeCity.Wpf.SpreadSheet.Dialogs.BuiltInDialogs.ConditionalFormatting

ConditionalFormatting Method

ConditionalFormatting(GcSpreadSheet, bool, FormatConditionType, FormatConditionOperator, bool, TopBottom, bool, int, int)

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

Declaration

public static IDialog ConditionalFormatting(GcSpreadSheet spread, bool createRule = false, FormatConditionType formatcoditionalType = FormatConditionType.CellValue, FormatConditionOperator cellValueOperator = FormatConditionOperator.Greater, bool isPercent = false, TopBottom topBottom = TopBottom.Top10Top, bool isAbove = true, int selectedRuleCategory = 0, int formatStyleIndex = 0)

Public Shared Function ConditionalFormatting(spread As GcSpreadSheet, Optional createRule As Boolean = False, Optional formatcoditionalType As FormatConditionType = FormatConditionType.CellValue, Optional cellValueOperator As FormatConditionOperator = FormatConditionOperator.Greater, Optional isPercent As Boolean = False, Optional topBottom As TopBottom = TopBottom.Top10Top, Optional isAbove As Boolean = True, Optional selectedRuleCategory As Integer = 0, Optional formatStyleIndex As Integer = 0) As IDialog

Parameters

Type	Name	Description
GcSpreadSheet	spread	The GcSpreadSheet control to work with.
bool	createRule	`true` to show the creating conditional formatting rule dialog.
FormatConditionType	formatcoditionalType
FormatConditionOperator	cellValueOperator
bool	isPercent
TopBottom	topBottom
bool	isAbove
int	selectedRuleCategory
int	formatStyleIndex

Returns

Type	Description
IDialog	The IDialog object represents the format cells dialog.