Get Schooled at New Horizons

Info and insights from New Horizons Computer Learning Centers. 22 locations to serve you.
Start exploring

Automatically apply a color gradient based on cell values (Excel 2016/2013/2010)

To get a quick handle on your data, change the color of your cells according to their numerical values. Select the entire block of data you want to format. Select the Home tab on the main ribbon, and then, in the Styles group, click on Conditional Formatting. Choose Color Scales from the resulting menu, and then mouse over the options to see a preview. Click on the option you prefer. Excel automatically applies a color gradient based on the range of numerical data in the cell. For example, if the data in your selected cells ranges from 1.29 to 275, and you choose the Red – Yellow – Green color scale, small numbers (e.g., 1.99) will be green, mid-range numbers (e.g., 12.49) will be yellow, and large numbers (e.g., 255) will be red. The smaller the number, the darker the shade of green. This striking graphic contrast allows you to quickly pick out the largest and smallest numbers in your selection, as well as the middle values.


Leave a Reply