Highlighting the highest and lowest values with Conditional Formatting
Back to conditional formatting menu
Try it yourself