Share via


FormatCondition.SetLastPriority Method

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

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub SetLastPriority
'Usage
Dim instance As FormatCondition

instance.SetLastPriority()
void SetLastPriority()

Remarks

The actual vaule of the priority will be equal to the total number of conditional formatting rules on the worksheet. When you have multiple conditional formatting rules in a worksheet, this method will cause the priority of rules that had a priority value greater than this rule to be increased by one.

Note

Priority levels for conditional formatting rules are applied on a worksheet-level basis.

See Also

Reference

FormatCondition Interface

FormatCondition Members

Microsoft.Office.Interop.Excel Namespace