![]() Choose the rule type “Format only cells that contain”.We will again select the data range containing the invoice values then go to “Home>Conditional Formatting>New rule” The initial steps involved are exactly the same.We have applied the first condition, now, we will move on to the application of the second condition.(Figure 3)įigure 3 – Result after application of the first condition After completing the above steps, the invoices having a value greater the $50,000 will be highlighted.Click “OK” for the formatting to come into effect.(Figure 2)įigure 2 – Selection and application of the first condition Click “Format” to display the Format Cells dialog box, choose the format as per your liking.In the “Format only cells with” section, select “Cell Value” in the first drop-down box and “greater than” from the second drop down. Choose “New Rule” from the drop-down menu. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |