{"id":2958,"date":"2022-03-10T10:11:31","date_gmt":"2022-03-10T13:11:31","guid":{"rendered":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/"},"modified":"2022-03-10T10:11:31","modified_gmt":"2022-03-10T13:11:31","slug":"how-to-conditional-formatting-based-on-another-cell-in-google-sheets","status":"publish","type":"post","link":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/","title":{"rendered":"How-To: Conditional Formatting Based on Another Cell in Google Sheets"},"content":{"rendered":"

Conditional formatting is a feature in Google Sheets<\/a> in which a cell is formatted in a particular way when certain conditions are met. The formatting can include highlighting, bolding, italicizing \u2013 just about any visual changes to the cell.<\/p>\n

Just as it can be done for the cell you\u2019re currently in, conditional formatting can also be set based on conditions met in another cell.<\/p>\n

<\/a><\/p>\n

Let\u2019s dive into how to create this condition based on multiple criteria.<\/p>\n

How Conditional Formatting Works<\/h2>\n

To learn how to set conditional formatting, let\u2019s use this workbook as an example.<\/p>\n<\/p>\n

It\u2019s a workbook showing website traffic year over year from Q4 2020 to Q4 2021, with the page views along with the year-over-year percentage change.<\/p>\n

Here\u2019s what we want to accomplish here: When the percentage change is positive YoY, the cell turns green. When it\u2019s negative, the cell turns red. This makes it easy to get a quick performance overview before diving into the details.<\/p>\n

Here are the steps to set the conditional formatting.<\/p>\n

1. Select the cell you want to format, click on “Format” from the navigation bar, then click on “Conditional Formatting.”<\/h3>\n

<\/h3>\n

<\/p>\n

2. While staying in the “Single color” tab, double-check that the cell under “Apply to range” is the cell you want to format. <\/h3>\n

<\/p>\n

3. Set your format rules.<\/h3>\n

It may automatically default to a standard conditional formatting formula. In this case, open the dropdown menu under “Format cells if\u2026” to select your rules. Options will look as follows:<\/p>\n

4. Choose your formatting style, then click “Done.”<\/span><\/h3>\n

5. Confirm the rule was applied under “Conditional Formatting Rules.”<\/h3>\n

6. Add another rule if needed.<\/h3>\n

<\/p>\n

7. Return to cell to view formatting, then drag the cursor to apply to other cells, if needed.<\/h3>\n

Now that you understand the basics, let\u2019s cover how to use conditional formatting based on other cells.<\/p>\n

Conditional Formatting Based on Another Cell Value<\/h2>\n

1. Select the cell you want to format.<\/h3>\n<\/p>\n

2. Click on “Format” in the navigation bar, then select “Conditional Formatting.”<\/h3>\n<\/p>\n

3. Under “Format Rules,” select “Custom formula is.”<\/h3>\n<\/p>\n

4. Write your formula, then click “Done.”<\/h3>\n<\/p>\n

5. Confirm your rule has been applied and check the cell.<\/h3>\n<\/p>\n

Conditional Formatting Based on Another Cell Range<\/h2>\n

To format based on another cell range, you follow many of the same steps you would for a cell value. What changes is the formula you write.<\/p>\n

1. Select the cell you want to format.<\/h3>\n<\/p>\n

2. Click on “Format” in the navigation bar, then select “Conditional Formatting.”<\/h3>\n<\/p>\n

3. Under “Format Rules,” select “Custom formula is.”<\/h3>\n<\/p>\n

4. Write your formula using the following format: =value range < [value], <\/strong>select your formatting style, then click “Done.”<\/h3>\n<\/p>\n

5. Confirm your rule has been applied and check the cell.<\/h3>\n<\/p>\n

Google Sheets Conditional Formatting Based on Another Cell Color<\/h2>\n

Currently, Google Sheets <\/a>does not offer a way to use conditional formatting based on the color of another cell. You can only use it based on:<\/p>\n

Values<\/strong> \u2013 higher than, greater than, equal to, in between
\n Text<\/strong> \u2013 contains, starts with, ends with, matches
\n Dates<\/strong> \u2013 is before, is after, is exactly
\n Emptiness<\/strong> \u2013 is empty, is not empty <\/p>\n

To achieve your goal, you\u2019d have to use the condition of the cell to format the other.<\/p>\n

Let\u2019s use an example.<\/p>\n<\/p>\n

Say you want to format cell A2 (September 2020) to be red and match the color of cell E2 (-20%). There\u2019s no formula that allows you to create a condition based on color. However, you can create a custom formula based on E2\u2019s values.<\/p>\n

You can say that if cell E2\u2019s values are less than 0, cell A2 turns red. The formula is as follows: = [The other cell] < [value].<\/strong> In this case, the formula would be =e2<0, as it signifies that cell A2 should turn red if E2\u2019s value is less than 0.<\/p>\n<\/p>\n

With so many functions to play with, Google Sheets can seem daunting. By following these simple steps, you can easily format your cells for quick scanning.<\/p>\n

<\/a><\/p><\/p>\n","protected":false},"excerpt":{"rendered":"

Conditional formatting is a feature in Google Sheets in which a cell is formatted in a particular way when certain conditions are met. The formatting can include highlighting, bolding, italicizing \u2013 just about any visual changes to the cell. Just as it can be done for the cell you\u2019re currently in, conditional formatting can also […]<\/p>\n","protected":false},"author":0,"featured_media":2959,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-2958","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-noticias-marketing"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"yoast_head":"\nHow-To: Conditional Formatting Based on Another Cell in Google Sheets - Contabilidade Caxias<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How-To: Conditional Formatting Based on Another Cell in Google Sheets - Contabilidade Caxias\" \/>\n<meta property=\"og:description\" content=\"Conditional formatting is a feature in Google Sheets in which a cell is formatted in a particular way when certain conditions are met. The formatting can include highlighting, bolding, italicizing \u2013 just about any visual changes to the cell. Just as it can be done for the cell you\u2019re currently in, conditional formatting can also […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Contabilidade Caxias\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-10T13:11:31+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/03\\\/10\\\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/03\\\/10\\\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\\\/\"},\"author\":{\"name\":\"\",\"@id\":\"\"},\"headline\":\"How-To: Conditional Formatting Based on Another Cell in Google Sheets\",\"datePublished\":\"2022-03-10T13:11:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/03\\\/10\\\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\\\/\"},\"wordCount\":656,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/03\\\/10\\\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/e7cd3f82-cab9-4017-b019-ee3fc550e0b5-Msjn9K.png\",\"articleSection\":[\"Marketing\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/03\\\/10\\\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/03\\\/10\\\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\\\/\",\"url\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/03\\\/10\\\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\\\/\",\"name\":\"How-To: Conditional Formatting Based on Another Cell in Google Sheets - Contabilidade Caxias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/03\\\/10\\\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/03\\\/10\\\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/e7cd3f82-cab9-4017-b019-ee3fc550e0b5-Msjn9K.png\",\"datePublished\":\"2022-03-10T13:11:31+00:00\",\"author\":{\"@id\":\"\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/03\\\/10\\\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/03\\\/10\\\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/03\\\/10\\\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\\\/#primaryimage\",\"url\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/e7cd3f82-cab9-4017-b019-ee3fc550e0b5-Msjn9K.png\",\"contentUrl\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/e7cd3f82-cab9-4017-b019-ee3fc550e0b5-Msjn9K.png\",\"width\":443,\"height\":59},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/03\\\/10\\\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How-To: Conditional Formatting Based on Another Cell in Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/#website\",\"url\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/\",\"name\":\"Contabilidade Caxias\",\"description\":\"Site especializado em Contabilidade para Caxias.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How-To: Conditional Formatting Based on Another Cell in Google Sheets - Contabilidade Caxias","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/","og_locale":"pt_BR","og_type":"article","og_title":"How-To: Conditional Formatting Based on Another Cell in Google Sheets - Contabilidade Caxias","og_description":"Conditional formatting is a feature in Google Sheets in which a cell is formatted in a particular way when certain conditions are met. The formatting can include highlighting, bolding, italicizing \u2013 just about any visual changes to the cell. Just as it can be done for the cell you\u2019re currently in, conditional formatting can also […]","og_url":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/","og_site_name":"Contabilidade Caxias","article_published_time":"2022-03-10T13:11:31+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. tempo de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/#article","isPartOf":{"@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/"},"author":{"name":"","@id":""},"headline":"How-To: Conditional Formatting Based on Another Cell in Google Sheets","datePublished":"2022-03-10T13:11:31+00:00","mainEntityOfPage":{"@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/"},"wordCount":656,"commentCount":0,"image":{"@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/contabilidadecaxias.com.br\/wp-content\/uploads\/2022\/03\/e7cd3f82-cab9-4017-b019-ee3fc550e0b5-Msjn9K.png","articleSection":["Marketing"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/","url":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/","name":"How-To: Conditional Formatting Based on Another Cell in Google Sheets - Contabilidade Caxias","isPartOf":{"@id":"https:\/\/contabilidadecaxias.com.br\/#website"},"primaryImageOfPage":{"@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/#primaryimage"},"image":{"@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/contabilidadecaxias.com.br\/wp-content\/uploads\/2022\/03\/e7cd3f82-cab9-4017-b019-ee3fc550e0b5-Msjn9K.png","datePublished":"2022-03-10T13:11:31+00:00","author":{"@id":""},"breadcrumb":{"@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/#primaryimage","url":"https:\/\/contabilidadecaxias.com.br\/wp-content\/uploads\/2022\/03\/e7cd3f82-cab9-4017-b019-ee3fc550e0b5-Msjn9K.png","contentUrl":"https:\/\/contabilidadecaxias.com.br\/wp-content\/uploads\/2022\/03\/e7cd3f82-cab9-4017-b019-ee3fc550e0b5-Msjn9K.png","width":443,"height":59},{"@type":"BreadcrumbList","@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/03\/10\/how-to-conditional-formatting-based-on-another-cell-in-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/contabilidadecaxias.com.br\/"},{"@type":"ListItem","position":2,"name":"How-To: Conditional Formatting Based on Another Cell in Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/contabilidadecaxias.com.br\/#website","url":"https:\/\/contabilidadecaxias.com.br\/","name":"Contabilidade Caxias","description":"Site especializado em Contabilidade para Caxias.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/contabilidadecaxias.com.br\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"}]}},"_links":{"self":[{"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2958","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=2958"}],"version-history":[{"count":0,"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2958\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/media\/2959"}],"wp:attachment":[{"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=2958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=2958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=2958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}