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:
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:
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.
