The answer is Top Ten items is the conditional formatting rule that is best suited to apply formatting to the top five values in a range of values. The excel conditional formatting top or bottom rules permits to put on formatting to cells that gratify a statistical condition in connection to other to other cells in a range. These conditions will only be applied to cells comprising numeric values. The top or bottom conditional formatting option is registered in the excel conditional formatting menu which in general situated in the styles group of the home tab of the excel ribbon. The top ten items dialog box opens up that permits the formatting to apply cells sustaining the chosen criteria and provides option of varying the values of 10 to a different value.
