< Go Back

Highlight top values

The ideal way to highlight top values in excel is by conditional formatting.

What are Highlight top values function in Excel?

In excel worksheet, conditional formatting with LARGE function returns highlight top values for the given array or set of data.

How the Highlight top values function is used in Excel?

To highlight top values in excel table, the LARGE function can be used to determine or highlight top values. For instance, if you want to find 5 highest top values in an array then first determine the 5 largest value using the LARGE function. The detailed guidance to find the highest top values is discussed in below sections.

Formula or Syntax

=A1> = LARGE (data, N)

Parameters or Arguments of a Highlight top values function

  •         Data: Required: It is a set of data or array for which k-th largest value is determined.
  •         K: Required: The largest position in the data to return.


An example of the highlight top values is given below. Follow the below steps to learn how to do it:

  1. First, create the table of some data as shown below. Now, to highlight top 5 values, first use LARGE function into the F8 cell to determine 5 largest values in a set of given data. In this example, it is 123.

Figure 1. Apply Large Function

  1. Now, to calculate value greater than 123, you need to use logical operation i.e. (>=). If values greater than 123 exist in data, then =A4> = LARGE (A4:D8, E2) returns true. To highlight top values, you can use conditional formatting.

Figure 2. The top 5 values are returned

Note on Usage of Highlight top values function

The notes on usage are listed below:

  •         LARGE function returns error value #NUM!  If the array is empty or K entered is greater than array data points.


Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment