This article will guide you to handle the Condition out of order in Excel.
| Join the channel Telegram of the AnonyViet 👉 Link 👈 |
Rules are not in order
This article will guide you to fix the rules that conflict with each other.
1. Value is 95 which is higher than 80 but also the highest value (Top 1). Format (yellow versus green and yellow text versus green text) conflicts. A higher Rule will always win. As a result, the value 95 is yellow.
Result:
2. Move the second rule to the first. The value 95 is the highest and is higher than 80. The formats will clash and the value 95 wins it will be blue.
Result:
In addition, you can also view many other excel articles here.
