How to apply a color scale based on values in Google Sheets.
Sometimes, adding color effects to a spreadsheet can be a great way to complement your data. If you are showing a range of values, such as Sales Total, for example, you can use color scales in Google Sheets.
With conditional formatting, you can easily scale two or three colors. In addition, you can take advantage of the preset color gradient or use custom colors. We’ll show you how to do both.
Apply Quick Conditional Formatting Color Scale.
If you want to quickly add color scales to Google Sheets, you can use one of the nine presets. Select the cells you want to format by first clicking on the cell and dragging the rest. Then, go to Format in the menu and select “Conditional Formatting”.
This conditional format opens the Rules sidebar, where you can sort everything you need. Above the sidebar, click the Color Scale tab. You will immediately see your selected cells with the default color scale. It gives you a great example of what your data will look like with Milan.
In the Apply Range box, confirm the cells you want to format and edit if necessary.
Then, to use a preset, click the color scale below the preview. Here, you will see your nine gradation options. If you wish, you can try each option by selecting one and then looking at your data.
By default, the values use the minimum and maximum for the color scale without a midpoint, but you can adjust these values in the next area. You can select a number, percentage, or percentile for each and add a midpoint if this applies. Then, type the values for these other options in the right boxes.
When you’re done setting up your rule, click “Done” at the bottom of the sidebar.
Create a custom conditional formatting color scale.
You may want to use a specific color for your scale. This could be your school color or your company logo. Google Sheets lets you create color scales just the way you want them.
You will follow these steps to set your formatting rules. Select Cells, click Format> Conditional Formatting from the menu, and confirm the cell range in the sidebar.
Click on the color scale below the preview and this time, select “Custom Color Scale” below. To get a head start, you can select a preset as the base for the custom scale.
Use the color buttons to display the palette to the right of each value, man point, midpoint and max point. You can select a color or click “Customize” below. Then, enter a hex code or use the slider and shade tool for the color you want.
When you’re done, click “Done” at the bottom of the sidebar to apply the rule.
Whether you use a preset or a custom color scale, the conditional formatting rule adjusts if you change your data. Therefore, when you edit, the formatting adjusts to these changes.
If you want to apply your color scale principle to the extra cells in your spreadsheet, you can copy the formatting to Google Sheets.