Hover your mouse over Color Scales and hover your mouse over the different options in the next box. Here youll see different formatting options of the data bars. If you want to look at the 20 items that are lowest in your inventory, then set the number to 20. Hover your mouse over TopBottom Rules and click Bottom 10 Items. It may be bad timing because you arent low on any items, but you have to order some anyway. If youre an inventory manager and your main supplier are closing for restoration for 3 months, youll have to refill your stock now before its too late. In this case, you need to delete some (if not all) of the rules in the sheet. If you dont want your cells to turn green when it includes the text L compatible (or something else), you can have it turn yellow instead. Here you edit your rule so it no longer triggers on a cell containing specific text, by choosing Blanks or Cell Value. You can also make the rule more advanced by basing it on a formula. If you dont want the conditional formatting to apply when something happens in a cell, you can change it to apply on all cells and filling them with color based on their value compared to the average of the data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |