Highlight Top 3 Values in Excel

In data analysis and MIS reporting, we often get the need to highlight the top and bottom values. This helps us to easily identify focus areas. In this article, we will learn how we can highlight the 3 highest values in Excel data set, using conditional formatting.

Let’s see an example to see how we can do this.
Example: Highlight 3 highest values in a data set
In range A2:C7 I have a formula =RANDBETWEEN(10,100). This formula generates a random number between 10 and 100, in each cell, whenever a change made in the file. I want to highlight the top 3 numbers in this range.

To highlight the top three values in excel, follow these steps:

  • Select the range.
  • Go to Home ? Conditional Formatting ? New Rule.
  • Here, select "format only top or bottom ranked value"
  • In the drop-down, select Top.
  • In the value box, write 3.
  • Select the formatting of the cell for top 3 values. I have selected a green fill.
  • Hit Ok. It is done. Now the top three values in this range will be highlighted with green fill dynamically.

This is easy. Isn't it?

So yeah, this how you can highlight top 3 values in a range. Using this method you can highlight n number of top values. There's no restriction in excel for that. If you have any doubts on this article or any other excel topic, mention it in the comments section below.

Related Articles:

Highlight Bottom 3 Values in a Range.

Highlight Bottom 3 Values in a Range with Criteria.

Conditional formatting based on another cell value

Conditional Formatting with formula 2016

Conditional Formatting using VBA in Microsoft Excel

Highlight cells that contain specific text

Popular Articles:

50 Excel Shortcut’s to Increase Your Productivity

The VLOOKUP Function in Excel

COUNTIF in Excel 2016

How to Use SUMIF Function in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.