Format Condition Methods

Name

Returns Parameters

Description

Delete

Deletes the formatting condition

Modify

Type As XlFormat ConditionType, [Operator], [Formulal], [Formula2]

[String], [Operator2]

Modifies the format ting condition. Since all the properties are read-only, this is the only way to modify the format condition

ModifyApplies ToRange

Range As Range

Sets the range for which the formatting rule will be applied

FormatCondition Object and the FormatConditions Collection Example

Name Returns Parameters Description

SetFirst Sets the priority

Priority value for the format ting rule so that it is evaluated before all other rules on the worksheet

Sets the priority value for the formatting rule so that it is evaluated after all other rules on the worksheet

0 0

Post a comment