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.
Below, I have a table with day wise sales and I want to highlight top 10 days with the highest sale (Table is bit long here).
It will instantly highlight top 10 values from the data with the formatting style you have mentioned.
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.
In Top/Bottom rule option in conditional formatting, you have some other useful options.
As I already said, I highlight top bottom values in all my reports.
And, this also helps the other person to get a quick insight, even if the data is just a table.
So, what do you think about this?
Do you have any other method to highlight top bottom values in excel?
Speak up in the comment box.