How to Highlight the Bottom 10% Items

Using conditional formatting, you can quickly highlight the cells with bottom 10 items or bottom 10% items, please see below for details. However, if you need to highlight bottom 10% items, please check How to Highlight the Bottom 10 Items.

Step 1: Select the data range;

Step 2: Click the "Home" tab from the Ribbon;

Step 3: Click the "Conditional Formatting" command in the "Styles" section;

Step 4: Click the "Top/Bottom Rules" command from the drop-down list, then select "Bottom 10%" from the extended list;

Step 5: In the next window, select the formatting style for the bottom 10% items (or to change 10 to any other numbers, e.g., top 5%);

Step 6: Click "OK" at the bottom and the bottom 10% values (one value in this example) will be in a different color.

Leave a Reply