RULE PRECEDENCE IN CONDITIONAL FORMATTING

Conditional Formatting in Excel makes tasks easier and more user-friendly but it can sometimes be confusing. When you use more than two conditions on similar data, it is known as Conditional Formatting with Multiple Conditions. In the last blog, we showed you how to use Conditional Formatting in easy steps. Today, we will learn about Rule Precedence in Conditional Formatting. So, let’s get started!

What is Rule Precedence?

When two or more rules are applied to the same range of data, these rules are evaluated based on their precedence (Top to Bottom) as indicated in the Manage Rules dialog box.

Let us learn more about this by following simple steps

1. In the image below, you will see that Column C has two formats. The blue cells highlight data between 4000 and 8000, whereas the green cells represent data between 8000 and 9000. If you look closely, you will realize that in September, the sales are 8000, which falls under the criteria for both rules, yet it is highlighted in green. You might be wondering why that is. Well, you will get your answer by following the steps below.

2. While applying formatting, Excel checks the precedence order and applies the rules accordingly. To check the precedence order, go to Conditional Formatting and select the option Manage Rules.

3. You will see a new dialog box where you can view the order of your formatting rules. In our case the rule ‘cell value between 8000 and 9000’ is placed above the rule ‘cell value between 4000 and 8000.’ This explains why the value 8000 appears in green in our data: the precedence order of ‘cell value between 8000 and 9000’ is higher than ‘cell value between 4000 and 8000.’

Note: By default new rules are always added to the top of the list and therefore have higher precedence. If you want it otherwise, you will need to change the order.

5. If you want to change the precedence order, simply select the first rule and click on the downward arrow. You will see that the positions of the rules have shifted. Click Apply.

6. You will see that the data has been rearranged according to the new precedence order. In our case, you will find that 8000 in the month of September is now highlighted in blue instead of green.

If you think this article has helped you in some way, don’t forget to share it with your friends. If you have any suggestions or queries, let us know in the comments box below.

Talk to our experts now

Conclusion:

Excel comes in handy for finance professionals as it helps them organize financial data, analyze it, and create complex financial models. Eventually, it leads to a clear presentation of financial information. It makes the work efficient, accurate, flexible, and easy to collaborate.

Do you know why a financial modeling course is important in the finance industry? It’s because it involves the practical application of various financial concepts learned. Its importance is paramount in the industry as it provides accurate projections of a company’s future financial performance. It is useful for valuing companies and making other important decisions.

So the important question is: are you looking for a trusted partner in this “creating complex financial model” journey? Your search ends here! With EduPristine as your training partner, you don’t need to worry about anything, whether it’s a concern about faculty or anything else. Both academic and administrative concerns are taken care of at EduPristine.

There are two things that we always encourage our students to undergo before making any decision about the choice of a training partner. First, check by getting on a call or perhaps visiting the center to ensure everything. Second, check the experience of their alumni base, maybe through their testimonials. This really helps with two things: one is to verify their offerings, and the other helps to assess their credibility.

Talk to our experts now

If we are to talk about our offerings, then it has to be our flexibility feature. We provide our students with the flexibility of hopping from one batch type to another (physical and virtual classes) without having to think about differential price payment. They also receive recordings of live virtual classes helping them to review concepts repeatedly for better understanding. Additionally, we grant them access to the Learning Management System for one full year. They can also attend ‘n’ number of batches for the price of one batch for one year. Apart from the flexibility aspect, our financial modeling course is in collaboration with the BSE Institute Limited, which generally brings the desired industry recognition.

The most important aspect of our financial modeling course is that the crucial module of Power BI is taught in our curriculum. Our faculty are selected after a rigorous process to ensure their suitability for the position. They also possess over 15 years of corporate experience, which naturally enables them to impart real-world scenarios to the students. At EduPristine, we have taught over 70,000 students and delivered training for more than 7 million hours over a span of 15 years, all with a focused emphasis on student success and employability. To enhance their employability, we also provide soft skill training at the end of each course, so students are well-prepared for the real world.

Talk to our experts now

We not only speak of these values but also act on them. After all of this, we invite you to book a free career counseling call with our expert counselors, who are ready to guide you through the financial modeling course curriculum, financial modeling course details, and address any doubts you may have. We also encourage you to visit our testimonial page to ensure the credibility of what we say about ourselves! Thank you, and happy learning!