FormatCondition.SetFirstPriority Method

Excel Developer Reference

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.

See Also