![]() Choose the rule type “Format only cells that contain”.Choose “New Rule” from the drop-down menu.Select the data range containing the invoice values, click on “Conditional Formatting” available on “Home” tab. ![]() ![]() In order to achieve this, we need to follow the below steps: Let’s assume that we have a set of different Sales Invoice data and we want to segregate invoices using conditional formatting which are either below or above $50,000. Normally, the data can be visually differentiated using one or more rules, however, in this article, we will discuss how to apply conditional formatting with 2 conditions.įigure 1 – Final result 1 Column, 2 Rules, 2 Conditions The conditional formatting is used to create visual differentiation in a large set of data, in some standard format. How Do You Do Conditional Formatting with 2 Conditions?
0 Comments
Leave a Reply. |