{"id":1486,"date":"2022-05-14T13:25:09","date_gmt":"2022-05-14T07:55:09","guid":{"rendered":"https:\/\/sheetstips.com\/?p=1486"},"modified":"2022-05-23T09:49:10","modified_gmt":"2022-05-23T04:19:10","slug":"how-to-apply-a-color-scale-based-on-values-in-google-sheets","status":"publish","type":"post","link":"https:\/\/sheetstips.com\/how-to-apply-a-color-scale-based-on-values-in-google-sheets\/","title":{"rendered":"How to Apply a Color Scale Based on Values in Google Sheets? (Conditional Formatting)"},"content":{"rendered":"<p>A Color Scale in Google Sheets helps us to add interactive color effects to the selected dataset. The color scale is highly useful when it comes to the analysis of web performance, sales data, user traffic on site, and so on. Also, Google Sheets automatically colors the cells based on the cell value.<\/p>\n<p>So, if you are planning to incorporate color scale to your data set in Google Sheets then this page is for you. On this page, you will understand everything about Color Scale under Conditional Formatting rules with the help of <strong><a href=\"https:\/\/sheetstips.com\/google-sheets-tips\/\" target=\"_blank\" rel=\"noopener\">Google Sheets tips<\/a><\/strong> provided. Read further to find more.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"601\">\n<p style=\"text-align: center;\"><strong>Table of Contents<\/strong><\/p>\n<ul>\n<li><a href=\"#Google-Sheets-Conditional-Formatting-Color-Scale-Based-on-Another-Cell\">Google Sheets Conditional Formatting Color Scale Based on Another Cell<\/a><\/li>\n<li><a href=\"#How-to-Apply-Custom-Color-Scale-in-Google-Sheets?\">How to Apply Custom Color Scale in Google Sheets?<\/a><\/li>\n<li><a href=\"#Google-Sheets-Color-Scale-Not-Working\">Google Sheets Color Scale Not Working<\/a><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"Google-Sheets-Conditional-Formatting-Color-Scale-Based-on-Another-Cell\">Google Sheets Conditional Formatting Color Scale Based on Another Cell<\/h2>\n<p>The following steps will answer you everything about \u201cHow do you make a cell change color based on value in Google Sheets?\u201d<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Open the Google Spreadsheet where you want to change the color of a cell-based on value.<\/li>\n<li><strong>Step 2:<\/strong> Select the cells where you want to apply the color scale.<\/li>\n<li><strong>Step 3:<\/strong> Now click on the \u201c<strong>Format<\/strong>\u201d tab in the menubar and choose \u201c<strong>Conditional Formatting<\/strong>\u201d from the drop down menu.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1487 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets.png\" alt=\"how-to-apply-a-color-scale-based-on-values-in-google-sheets\" width=\"664\" height=\"544\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets.png 664w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets-300x246.png 300w\" sizes=\"(max-width: 664px) 100vw, 664px\" \/><\/p>\n<ul>\n<li><strong>Step 4:<\/strong> The Conditional Formatting window will open towards the left side of the screen.<\/li>\n<li><strong>Step 5:<\/strong> Click on the Color Scale to move towards the Color Scale pane.<\/li>\n<li><strong>Step 6:<\/strong> Now under \u201c<strong>Apply to Range<\/strong>\u201d select the range of the cells where you want to apply the Google Sheets color scale.<\/li>\n<li><strong>Step 7:<\/strong> Under \u201c<strong>Format Rules<\/strong>\u201d you will have default colors. Choose the color scale which you would like to apply.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1488 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets1.png\" alt=\"how-to-apply-a-color-scale-based-on-values-in-google-sheets\" width=\"1127\" height=\"447\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets1.png 1127w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets1-300x119.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets1-1024x406.png 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets1-768x305.png 768w\" sizes=\"(max-width: 1127px) 100vw, 1127px\" \/><\/p>\n<ul>\n<li><strong>Step 8:<\/strong> This will simply apply the color scale based on the cell value.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1489 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets2.png\" alt=\"how-to-apply-a-color-scale-based-on-values-in-google-sheets\" width=\"1219\" height=\"338\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets2.png 1219w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets2-300x83.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets2-1024x284.png 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets2-768x213.png 768w\" sizes=\"(max-width: 1219px) 100vw, 1219px\" \/><\/p>\n<p>Now to apply the color scale based on the cell value using the conditional formatting follow the steps below:<\/p>\n<ul>\n<li><strong>Step 9:<\/strong> Now in the below section, you will see 3 options namely &#8211; Minpoint, MidPoint, Maxpoint. Under Minpoint, select the option suitable for your dataset and set the Minpoint with the desired number.<\/li>\n<li><strong>Step 10:<\/strong> Choose the \u201c<strong>Color<\/strong>\u201d which you would like to display for Minpoint by clicking on the Min Point Color.<\/li>\n<li><strong>Step 11:<\/strong> Repeat Steps 8 and 9 for Midpoint and Maxpoint.<\/li>\n<li><strong>Step 12:<\/strong> Click on the \u201c<strong>Done<\/strong>\u201d button.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1490\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets3.png\" alt=\"how-to-apply-a-color-scale-based-on-values-in-google-sheets\" width=\"1270\" height=\"426\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets3.png 1270w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets3-300x101.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets3-1024x343.png 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets3-768x258.png 768w\" sizes=\"(max-width: 1270px) 100vw, 1270px\" \/><\/p>\n<p>That\u2019s it, as per the conditions you have set under Min, Mid, and Max point, the cell color will change as and when the value of the cell is being changed.<\/p>\n<ul>\n<li><a href=\"https:\/\/sheetstips.com\/heat-map-google-sheets\/\">How to Create and Use Heat Map in Google Sheets With Examples<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/conditional-formatting-google-sheets\/\">The Ultimate Guide to Using Conditional Formatting in Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/search-in-google-sheets\/\">How to Search in Google Sheets and Highlight Matching Data? (4 Easy Methods)<\/a><\/li>\n<\/ul>\n<h3 id=\"How-to-Apply-Custom-Color-Scale-in-Google-Sheets?\">How to Apply Custom Color Scale in Google Sheets?<\/h3>\n<p>In order to add the custom color scale to your Google Sheets based on the cell value, follow the same steps mentioned here:<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Select the cell where you want to apply the custom color scale based on the value.<\/li>\n<li><strong>Step 2:<\/strong> Click on the \u201c<strong>Format<\/strong>\u201d tab and choose \u201c<strong>Conditional Formatting<\/strong>\u201d from the drop down menu.<\/li>\n<li><strong>Step 3:<\/strong> Now click on the \u201c<strong>Color Scale<\/strong>\u201d pane.<\/li>\n<li><strong>Step 4:<\/strong> Under the \u201c<strong>Format rules<\/strong>\u201d choose \u201c<strong>Custom color scale<\/strong>\u201d and start customizing the colors which you want to display.<\/li>\n<li><strong>Step 5:<\/strong> Click on the \u201c<strong>Done<\/strong>\u201d button.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1490 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets3.png\" alt=\"how-to-apply-a-color-scale-based-on-values-in-google-sheets\" width=\"1270\" height=\"426\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets3.png 1270w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets3-300x101.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets3-1024x343.png 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-apply-a-color-scale-based-on-values-in-google-sheets3-768x258.png 768w\" sizes=\"(max-width: 1270px) 100vw, 1270px\" \/><\/p>\n<h3 id=\"Google-Sheets-Color-Scale-Not-Working\">Google Sheets Color Scale Not Working<\/h3>\n<p>In some instances, the Google Sheets color scale may not work. To make it start working again, clear the formatting you have applied in your sheets and start creating the custom color scale again. To clear the formatting, choose the \u201c<strong>Format<\/strong>\u201d option in the menubar and choose \u201c<strong>Clear Formatting<\/strong>\u201d from the drop down menu.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A Color Scale in Google Sheets helps us to add interactive color effects to the selected dataset. The color scale is highly useful when it comes to the analysis of web performance, sales data, user traffic on site, and so on. Also, Google Sheets automatically colors the cells based on the cell value. So, if &#8230; <a title=\"How to Apply a Color Scale Based on Values in Google Sheets? (Conditional Formatting)\" class=\"read-more\" href=\"https:\/\/sheetstips.com\/how-to-apply-a-color-scale-based-on-values-in-google-sheets\/\" aria-label=\"More on How to Apply a Color Scale Based on Values in Google Sheets? (Conditional Formatting)\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/1486"}],"collection":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/comments?post=1486"}],"version-history":[{"count":5,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/1486\/revisions"}],"predecessor-version":[{"id":2544,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/1486\/revisions\/2544"}],"wp:attachment":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media?parent=1486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/categories?post=1486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/tags?post=1486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}