Abdul Alim: a little bit learning, let's go

Excel, VBA and Power BI tutorials 

Chapter-8: Format Only Top Or Bottom Ranked Values

“Format only top or bottom ranked values” rule is used to highlight the Top n items or Bottom n Items. We also can highlight Top n% items or Bottom n% Items.

To apply “Format only top or bottom ranked values” rule below are the steps 

• Select the range on which you want to apply the conditional formatting

• As in below image select “B2:G9”

• Go to Home tab>>Conditional Formatting>>New Rules

• New formatting rule window will be opened.

• Select “Format only top or bottom ranked values“

There are two type of rule can be applied – Top and Bottom

1.Top:

• Select Top and put the item count

• If you want to highlight Top n% then tick the check box “% of select range“

• Here we are highlighting Top 10 items

• click on Format button.

• Format Cells window will be opened.

• Give the formatting which you want to apply on the excel cells

• Click on OK button to apply this conditional formatting.

• Data set with this conditional formatting will look like below image.

1.Bottom:

• Select Bottom and put the item count

• If you want to highlight Bottom n% then tick the check box “% of select range“

• Here we are highlighting Bottom 10 items

• Click on OK button to apply this conditional formatting.

• Data set with this conditional formatting will look like below image.