![]() It must be said, you could do as many rules as you like, and you will still be able to turn them all on or off with one click. In the dialog box that follows, you can change the number of Top items and the format of the cell, but I will just go with the defaults. So we select the cells and go to Home/Conditional Formatting/Top Bottom Rules/Top 10 Items Our goal is simple, to highlight the top 10 values. It can quite as easily be a simple cell where you manually put in “Yes” and “No”. Note the Data Validation dropdown in cell B1. In our case, let’s take a look at the following example in Excel. ![]() Here the original rule is the one we wish to turn on and off. Fixing all the settings in order for the toggling of Conditional Formatting to work.Ĭreating the original rule with conditional Formatting
0 Comments
Leave a Reply. |