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())

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

Worksheet Class
Worksheet Members