Question

Top/Bottom Rules allow a user to apply conditional formatting to cells that fall within the top or bottom numbers or percentile. How many items will it allow the user to include in the rule? the top or bottom 10 items or top or bottom 10% only the top 10 items and top 10% only the top or bottom 100 items only any logical number of items or percentages in top or bottom value frames

Answer 1

Explanation:

This allows you to choose the formatting to apply to cells satisfying the chosen criteria. ( e.g. Top Ten Items, Top Ten %, etc). Conditional ...