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.
