Priority Property (ConditionBase)

Returns or sets a value which determines the order of evaluation when multiple conditional formatting rules exist.

Syntax

Visual Basic

'Declaration
 
Public Property Priority As Integer

C#

public int Priority {get; set;}

Remarks

By default, conditions are evaluated in the order in which they appear within the containing collection.

This property makes it possible to weight one condition over another, essentially overriding the condition's ordinal position within the collection.

A lower number means a higher priority; for example, a condition with a priority of 1 is evaluated before one with a priority of 2.

If a cell value meets more than one condition, the format defined by the first condition to be evaluated takes precedence.

Setting the priority on one condition may cause the value of other conditions in the collection to be changed to ensure that each condition has a unique value.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2