ConditionalFormats Property

Gets the conditional format for the sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property ConditionalFormats As ConditionalFormat

'Usage
 
Dim instance As Worksheet
Dim value As ConditionalFormat
 
value = instance.ConditionalFormats

public ConditionalFormat ConditionalFormats {get;}

Property Value

The conditional format for the sheet.

Example

This example uses the ConditionalFormats property.

listBox1.Items.Add(GcSpreadSheet1.Sheets[0].ConditionalFormats.RuleCount.ToString());
listBox1.Items.Add(GcSpreadSheet1.Sheets[0].CustomFunctions.IsReadOnly.ToString());
listBox1.Items.Add(GcSpreadSheet1.Sheets[0].CustomNames.IsReadOnly.ToString());

VB.NET

ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).ConditionalFormats.RuleCount.ToString())
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).CustomFunctions.IsReadOnly.ToString())
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).CustomNames.IsReadOnly.ToString())

Reference

Worksheet Class
Worksheet Members