Excel Tip # 7 - Automatically highlight highest and lowest values in a range of cells in excel 2016

In this video, i describe how to automatically highlight highest and lowest values in a range of cell in excel 2016. It is helpful when you are looking lowest and highest values in the dataset.

[JJWilli]

Ok great. I know how to highlight the max value in a single column now. But what if I wanted to highlight the max value in row 1, 2, 3, ..., 500 without having to do every single row or column individually.