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.SetFirstPriority Method

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

Version Information
 Version Added:  Excel 2007



expression   A variable that represents a FormatCondition object.


When you have multiple conditional formatting rules in a worksheet, if the rule was not previously set to priority "1", this method will cause the priority of all other existing rules on the worksheet to be increased by one.

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

Community Additions

© 2014 Microsoft