The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

FormatCondition.SetLastPriority Method

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

Version Information
 Version Added:  Excel 2007



expression   A variable that represents a FormatCondition object.


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.

Bb238843.vs_note(en-us,office.12).gif  Note
Priority levels for conditional formatting rules are applied on a worksheet-level basis.

Community Additions

© 2015 Microsoft