Conflicting Rules

 

Sometimes multiple conditional formatting rules in Excel conflict. A higher rule always wins. This example illustrates two different results.

1. The value 95 is higher than 80 but is also the highest value (Top 1). The formats (yellow fill vs green fill and yellow text color vs green text color) conflict. A higher rule always wins. As a result, the value 95 is colored yellow.

Conflicting Conditional Formatting Rules 1

Result:

Conflicting Conditional Formatting Rules 1 Result

2. Move the second rule up. The value 95 is the highest value (Top 1) but is also higher than 80. The formats (green fill vs yellow fill and green text color vs yellow text color) conflict. A higher rule always wins. As a result, the value 95 is colored green.

Conflicting Conditional Formatting Rules 2

Result:

Conflicting Conditional Formatting Rules 2 Result

Note: only use the Stop If True check boxes for backwards compatibility with earlier versions of Microsoft Excel.

Previous articleCalculated Field/Item in a Pivot Table – Easy Excel
Next articleCount Cells with Text in Excel