Set the background color of a range of cells according to their numeric value, similar to the Excel feature.
The Color Scale add-on for Google Sheets sets the background color of the cells in a selected range according to their numeric value. This is similar to the ‘color scales’ or color gradient feature in Microsoft Excel. The lowest number found in the selection is set to the low color, the highest value to the high color and every value in between is colored on a sliding scale according to their position between the high and the low.
Create a new Google Sheet on your Google Drive and install the Color Scale add-on (Add-ons>Get add-ons…). After installing it ‘Add-ons>Color Scale>Choose colors’ menu to select a low and high color for your selection of numbers, then use ‘Apply color scale to selection’ to apply the colors.
Contact me (Andrew Roberts - firstname.lastname@example.org) if you have any questions or suggestions.
You can also get more information off the website (andrewroberts.net/portfolio/google-sheet-color-scale/) or follow me on twitter (andrewroberts6) for the latest updates.