TOP / BOTTOM RULES

How to use and apply the Top / Bottom rules in conditional formatting please follow the step shown below and example in image and video. TOP 10 ITEMS:- When you apply this highlighting rule it will highlight the top 10 highest number from the table range. TOP 10%:- When you apply this highlighting rule it will highlight the top 10% of the table count cell. Suppose there are 24 cell are there in a selected table and 10% of 24 is 2.4% then it will highlight 2 top value of the entire table range. BOTTOM 10 ITEMS:- When you apply this highlighting rule it will highlight the bottom 10 lowest number from the table range. BOTTOM 10%:- When you apply this highlighting rule it will highlight the bottom 10% of the table count cell. Suppose there are 24 cell range selected and...