Question

Top/Bottom Rules allow you to apply conditional formatting to cells that fall within
the top or bottom numbers or percentile. How many items will it allow you to
include in the rule?

Answer 1

Answer:

When you select one of the Top/Bottom Rules from the menu, the 'Top Ten Items' dialog box opens up (see below). This allows you to choose the formatting to apply to cells satisfying the chosen criteria. (e.g. Top Ten Items, Top Ten %, etc).

Hope it would be helpful

Answer 2

The default number of things is 10, yet you can determine any entire number up to 1000 for Top/Bottom Items to be highlighted. You can pick any reach for where the Highlight Cell Rule ought to apply.

• Top/Bottom Rules are premade sorts of restrictive organizing in Excel used to change the presence of cells in a reach-in light of your predefined conditions.
• On the Home tab, click Conditional Formatting > New Rule. In the New Formatting Rule exchange box, pick Format just top or bottom positioned values.
• In the drop-down list, select Top or Bottom and type the number of values to highlight in the case close to it.
• The Excel Conditional Formatting Top/Bottom Rules permit you to apply arranging to cells that fulfill a measurable condition according to different cells in the reach (for example better than expected, inside top 10%, and so on)
• These circumstances might be applied to cells containing numeric qualities.