Browsing: Spreadsheet

This tutorial will teach us how to use color scale in Google Sheets. The purpose of the color scale is to present your data with a set of colors. For example, if your data consists of numbers from 1 to 5, you can add a color scale to divide it into three groups. Three belong to the mid group, 1-2 to the lowest group, and 4-5 to the maximum group. As a result, the colors will be the lightest for maximum values, the darkest for minimum values, and the average color for mid values.