By applying conditional formatting to your data, you can quickly identify variances in a range of values with a quick glance.
This graphic shows temperature data with conditional formatting that uses a color scale to differentiate high, medium, and low values. The following procedure uses that data.
Select the all the data in a table.
Select Conditional Formatting > Top/Bottom Rules > Top 10 Items to see the 10 largest numbers in the table.
Select Conditional Formatting > Data Bars, Color Schemes, or Icon Sets to see how your data can be instantly analyzed. Press Ok when done.