TOP BOTTOM RULES In Excel Conditional Formatting
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...