How to Use Color Scale in Sheets – Guide
With the Google Sheets conditional formatting element, you can make your data stand out and be more easily visualized. For example, you can use it to feature meaningful cells in your information that meet a certain condition, or to apply some three-color scales to help visualize how close or distinct the values are.
How to Apply a value-based color scale in Google Sheets
Example 1
Then, we select the color that we want to use as our starting point. In this example, we will use the color blue. Next, we divide the range into thirds. In this example, we will divide it into thirds to create a scale from blue (C4), to green (C7), and to red (C12). ..
Conditional Formatting lets you control how text appears based on certain conditions.
If the user has not clicked on the “Conditional Formatting” button, the pop-up will not appear.
There are three color scales to choose from: the red to white scale, the color wheel, and custom. The red to white scale is the most common and simplest. It just has one color, red, and one value, white. To use it, just pick a preset or customize it based on your preference. The color wheel is more complex but can be more versatile. It has six colors, each with a different value. To use it, you first need to choose a color and then set its value to another color. Customizing it is even more complicated but can be very helpful if you want to create a custom scale that works best for you.
As you can see in the preview, the maximum point would be red and the minimum point would be white. We wouldn’t need to enter a midpoint as we’re not concerned with that at the moment. ..
After pressing Done, your spreadsheet will look like this.
To create a spreadsheet like this, you will need to do the same for the remaining subjects. ..
To meet students who have scored more than 80 points in each subject, we can simply set Maxpoint to ‘100’ and Minpoint to ’80’. We also changed Minpoint to White and Maxpoint to Red.
After we’re done with the new entries, our spreadsheet will only show color scaling to those who scored 80 and over. The brightest red is the highest grade among the group for that matter. ..
Example 2
We can also apply the color scale to dates. Suppose you are the leader of a three-person team for a marketing services company. You’ve created a shared Google Sheets with them to keep track of everyone’s tasks and deadlines. However, since there are so many deadlines and tasks, it is difficult to track what is urgent to complete. You can apply the color scale feature to the dates to categorize them by urgency. The color red would be the dates closest to you and green would be the dates further away from you. Let’s do it together step by step!
We would like to apply the color scale to the range A4:A8. ..
The conditional formatting rule appears on the right side of the screen. You can select a color scale to apply the formatting to.
In the preview section, you can choose between green and yellow for the color scale, and red. ..
We need to adapt the color to change from red to yellow to green as we would like to show the date lines closest to us in red.
The earliest date would be interpreted as the minimum point, and the most distant date would be interpreted as the maximum point. So let’s select Red for minpoint and Green for maxpoint. The midpoint would remain yellow.
After pressing Done, the spreadsheet will look like this.
Final note
In this guide, we will be discussing the use of color scales in sheets. By understanding how to use color scales, you can create charts and graphs that are more effective and appealing to the viewer. ..
