Edit

Share via

FormatCondition.SetFirstPriority method (Excel)

  • Article

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

Syntax

expression.SetFirstPriority

expression A variable that represents a FormatCondition object.

Remarks

When you have multiple conditional formatting rules on 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.

Note

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.