FormatCondition Methods (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Methods

Name

Description

Delete

Deletes the object.

Modify

Modifies an existing conditional format.

ModifyAppliesToRange

Sets the cell range to which this formatting rule applies.

SetFirstPriority

Sets the priority value for this conditional formatting rule to "1" so that it will be evaluated before all other rules on the worksheet.

SetLastPriority

Sets the evaluation order for this conditional formatting rule so it is evaluated after all other rules on the worksheet.