You would use the conditional formatting options when analyzing a worksheet in which you want to highlight the highest or lowest values compared to other cells in the selection.

Top/bottom conditional formatting

Explanation:

The top/bottom conditional formatting automatically carries out the task of finding the highest, lowest and even average values.

Conditional formatting formatting gives one the opportunity to enhance reports and dashboards as they work on excel.

You use the too/bottom formatting to highlight cells whose values of highest in a dataset and lowest in a dataset

i think ninja is the best