Скачать или смотреть Using Conditional Formatting to Highlight Top-Bottom N Values in Excel

Using Conditional Formatting to Highlight Top-Bottom N Values in Excel

The best way to highlight top bottom values is by using conditional formatting.

It’s quick, simple and all you need a few clicks.

But, the best part is, you don’t even have to write a formula for this.
I have been using this since I have got my first job.

Whenever my boss called me with some sort of reports, I do it for sure to highlight top and bottom values.

And, if you are not using it yet, let me tell you how to use it.

Steps To Highlight Top Bottom Values

Below, I have a table with salary and I want to highlight top 10 salary earners

First of all, select the data from which you want to highlight top values.
Go to Home Tab - Styles - Conditional Formatting -Top/Bottom Rules - Top 10.

Now, in the pop-up window, you have two things to specify.

1. Numbers of values to highlight (top 10 for now).

2. Formatting to use for highlighting values.

After that, click okay.

It will instantly highlight top 10 values from the data with the formatting style you have mentioned.

Bottom 10 Values
For highlighting bottom 10 values, you can use the same steps.
But instead of top 10, just click on bottom 10 and rest of the things are same.

Select numbers of values to highlight.
And, format to use.