#Conditional formatting definition excel how to#

Now this is the answer to your question in step 1.

In our case the Rule вЂcell value between 8000 to 9000вЂ™ is placed above the Rule вЂcell value between 4000 to 8000вЂ™. You shall see a new dialog box in which you can see the order of your formatting. To check the precedence order, go to conditional formatting and select the option of Manage Rules.ДЈ. While applying the formatting, excel checks the precedence order and then it applies the rules accordingly. Now you are wondering why is that? Well you will get your answer by going through the steps below.Дў. If you look closely, then you will realize that in the month of September the sales is 8000 which falls in both our rules criteria, but then too it is highlighted as green. The blue cells highlight the data between 4000 to 8000 whereas the green ones represent data between 8000 to 9000.

In the image below you will see that the Column C has two formatting. Let us learn more about it by following simple steps:ДЎ. When two or more Rules are applied to the same range of data then these rules are evaluated on the basis of precedence (Top to Bottom) mentioned in the dialog box of manage rules. Today, we shall learn about the Rule Precedence in Conditional Formatting.

#Conditional formatting definition excel how to#

In the last blog we showed you How to use Conditional Formatting in easy steps. When you are using more than two conditions on similar data then it is known as Conditional Formatting using Multiple Conditions. Conditional Formatting in Excel makes the things easier and user friendly, but at times it may also make it quite confusing.