 Visualizing your business results is the best way to go when analyzing and planning how to make improvements. Excel 2016 has a practical yet powerful tool that enables you to do just that. Rod here and welcome to Burn to Learn. As the owner of a store, you want to analyze sales in each month last year and develop merchandising promotion ideas to boost business in those months when unit sales fell below your break-even point of 1,000. Here we have a list of your unit sales each month. Let's see how Excel 2016 helps you to analyze these results visually. First, select the range of units sold. Now go to Conditional Formatting, then select Highlight Cell Rules. But before showing you what steps to take next, we ask that you like this video after watching and please comment. As you can see, there are several conditions to choose from. Select Less Than. Now you indicate in the first box the condition you want to be fulfilled. This time you select our cell N9. Now go to the second box and indicate the style you want to appear in your selection. You can choose any option or create your own style in custom format. But this time you choose Green Fill with Dark Green Text. As you can see, now the months with sales below your break-even point are highlighted in green. And now you can focus your merchandising plans to boost sales in these months. And if your break-even point ever changes, simply change the amount and Excel automatically changes the highlights to the correct months. And whenever you want to clear your format, just go to Conditional Formatting, select Clear Rules, and choose Clear Rules from Selected Cells. And the format is removed. Now you know how to visually analyze your business results using Conditional Formatting in Excel 2016. Please remember to make a comment about this video. Share it and hit the like button. And please subscribe to our channel and receive our videos automatically. Thanks so much for watching.