This form can be used to add, edit, and remove conditional formats for a cell or a range of cells. To use the form, create an instance of the ConditionalFormatForm class, by providing the related workbook and the IStyle object of the target cell or range of cells, and call the ShowDialog method. To apply the changes made through the form, call the Apply method. The following image shows the form:

The code below demonstrates how to display the conditional format form for an existing CellRange instance.

C#  Copy Code
var form = new ConditionalFormatForm(workbook, cellRange.Style); if (form.ShowDialog() == DialogResult.OK) {     worksheet.BeginInit();     using (workbook.StartChangeOperation(worksheet))         form.Apply(cellRange.Style);     worksheet.EndInit(); }

Visual Basic  Copy Code
Dim form = New ConditionalFormatForm(workbook, cellRange.Style) If form.ShowDialog() = DialogResult.OK Then     worksheet.BeginInit()     Using workbook.StartChangeOperation(worksheet)         form.Apply(cellRange.Style)     End Using     worksheet.EndInit() End If

System.Object
    System.MarshalByRefObject
        System.ComponentModel.Component
            System.Windows.Forms.Control
                System.Windows.Forms.ScrollableControl
                    System.Windows.Forms.ContainerControl
                        System.Windows.Forms.Form
                            MindFusion.Spreadsheet.WinForms.ConditionalFormatForm

ConditionalFormatForm Members
MindFusion.Spreadsheet.WinForms Namespace