Ever popular in the Script Gallery, Color Scale is now available as an add-on in the Google Web Store for adding to your own Google Sheets.
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.
Drop me a line if you come up with any cool visualisations, I’ve been playing with terrain generation.
