Edit

Share via

AboveAverage.SetLastPriority method (Excel)

  • Article

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

Syntax

expression.SetLastPriority

expression A variable that represents an AboveAverage object.

Remarks

The actual value of the priority will be equal to the total number of conditional formatting rules on the worksheet. When you have multiple conditional formatting rules on a worksheet, this method will cause the priority of rules that had a priority value greater than this rule to be decreased 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.