Four methods to highlight the smallest number in a range

 

4 Methods to highlight the smallest number in a range

 

In Excel, as you might know, there is (almost) always an alternative method to accomplish a certain task.

In this post I’m going to show your 4 different methods to highlight the smallest number in a range:

 

                                                        Method 1: Using Top/Bottom Rules

 

 

Method 2: Using a formula (MIN function)

 

 

Method 3: Using a formula (SMALL function)

 

 

 

          Method 4: Using a formula (LARGE function)