ConditionalFormats type

Represents a format condition class.

Syntax

var instance = new GC.Spread.Sheets.ConditionalFormatting.ConditionalFormats(worksheet);

function ConditionalFormats;

Inheritance Hierarchy

Object
GC.Spread.Sheets.ConditionalFormatting.ConditionalFormats

Constructors

	Name	Description
	ConditionalFormats Constructor	Represents a format condition class.

Methods

	Name	Description
	add2ScaleRule	Adds the two scale rule to the rule collection.
	add3ScaleRule	Adds the three scale rule to the rule collection.
	addAverageRule	Adds an average rule to the rule collection.
	addCellValueRule	Adds the cell value rule to the rule collection.
	addDataBarRule	Adds a data bar rule to the rule collection.
	addDateOccurringRule	Adds the date occurring rule to the rule collection.
	addDuplicateRule	Adds a duplicate rule to the rule collection.
	addFormulaRule	Adds the formula rule to the rule collection.
	addIconSetRule	Adds an icon set rule to the rule collection.
	addRule	Adds the rule.
	addSpecificTextRule	Adds the text rule to the rule collection.
	addTop10Rule	Adds the top 10 rule or bottom 10 rule to the collection based on the Top10CondtionType object.
	addUniqueRule	Adds a unique rule to the rule collection.
	clearRule	Removes all rules.
	containsRule	Determines whether the specified cell contains a specified rule.
	count	Gets the number of rule objects in the collection.
	getRule	Gets the rule using the index.
	getRules	Gets the conditional rules from the cell at the specified row and column.
	removeRule	Removes a rule object from the ConditionalFormats object.
	removeRuleByRange	Removes the rules from a specified cell range.