Conflicting Rules in Excel

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.

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.

Result:

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

If you're new here, welcome to Excel Easy! Join over 1 million monthly Excel learners. You can find popular courses here: Excel Functions and Data Analysis in Excel.