{"id":66932,"date":"2023-05-11T21:01:58","date_gmt":"2023-05-11T13:01:58","guid":{"rendered":"https:\/\/www.hongkiat.com\/blog\/?p=66932"},"modified":"2023-05-10T18:57:38","modified_gmt":"2023-05-10T10:57:38","slug":"google-sheets-click-highlight-row","status":"publish","type":"post","link":"https:\/\/www.hongkiat.com\/blog\/google-sheets-click-highlight-row\/","title":{"rendered":"How to Highlight a Row in Google Sheets Based on a Checkbox"},"content":{"rendered":"<p>Have you ever considered using Google Sheets to perform the following action: clicking on a checkbox causes the entire row to become highlighted in a color of your choice? This can be extremely useful for marking specific tasks as completed.<\/p>\n<p>Here is a step-by-step guide on how to achieve this.<\/p>\n<h3>Step 1<\/h3>\n<p>First, make sure you have checkboxes in your sheet. If not, you can add them by clicking the cell where you want a checkbox, then going to \u201c<strong>Insert<\/strong>\u201d in the top menu and selecting \u201c<strong>Checkbox<\/strong>.\u201d<\/p>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-click-highlight-row\/select-checkbox.jpg\" alt=\"insert checkbox\" width=\"1542\" height=\"1096\"><\/figure>\n<h3>Step 2<\/h3>\n<p>Once you have your checkboxes set up, you can create a new conditional formatting rule. To do this, click on \u201c<strong>Format<\/strong>\u201d in the top menu, then select \u201c<strong>Conditional formatting.<\/strong>\u201c<\/p>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-click-highlight-row\/format-conditional-formatting.jpg\" alt=\"Conditional formatting\" width=\"1647\" height=\"1050\"><\/figure>\n<h3>Step 3<\/h3>\n<p>In the conditional formatting panel that opens on the right side, under the \u201c<strong>Format cells if<\/strong>\u201d drop-down, select \u201c<strong>Custom formula is.<\/strong>\u201c<\/p>\n<figure class=\"screenshot-mobile-portrait\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-click-highlight-row\/custom-formula-is.jpg\" alt=\"custom formula is...\" width=\"845\" height=\"1899\"><\/figure>\n<h3>Step 4<\/h3>\n<p>In the field below, enter a formula that references the cell with the checkbox. If your checkbox is in column A and you want to apply this to the whole sheet, you would write <code>=$A1=True<\/code>. The dollar sign (<code>$<\/code>) before <code>A<\/code> makes the column absolute, so it won\u2019t shift when applied to the whole row, and <code>1<\/code> should be the first row number of your data range.<\/p>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-click-highlight-row\/a1-true.jpg\" alt=\"$A1=True\" width=\"695\" height=\"349\"><\/figure>\n<h3>Step 5<\/h3>\n<p>After entering the formula, select the formatting style you want to apply when the checkbox is checked. You can set the background color, text color, and more. In this case, we will change the background color to green, as an accomplished task is usually associated with the green color.<\/p>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-click-highlight-row\/set-color-and-styles.jpg\" alt=\"set color and style\" width=\"1039\" height=\"994\"><\/figure>\n<h3>Step 6<\/h3>\n<p>Finally, under \u201c<strong>Apply to range<\/strong>\u201c, enter the range where you want this rule to apply.<\/p>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-click-highlight-row\/apply-to-range.jpg\" alt=\"apply to range\" width=\"696\" height=\"634\"><\/figure>\n<p>If you want it to apply to the entire row, just click on the row number on the left and the entire row will be selected.<\/p>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-click-highlight-row\/row-selected.jpg\" alt=\"row selected\" width=\"1915\" height=\"660\"><\/figure>\n<h3>Step 7<\/h3>\n<p>Click \u201c<strong>Done<\/strong>\u201d to apply the rule. Here\u2019s what it looks like when you click on the checkbox.<\/p>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-click-highlight-row\/checkbox%20clicked.gif\" alt=\"checkbox clicked\" width=\"1644\" height=\"667\"><\/figure>","protected":false},"excerpt":{"rendered":"<p>A step-by-step Google Sheets guide on how to highlight or style the entire row when a checkbox is clicked.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3398],"tags":[4554],"topic":[],"class_list":["entry-content","is-maxi"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.8 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Highlight a Row in Google Sheets Based on a Checkbox - Hongkiat<\/title>\n<meta name=\"description\" content=\"A step-by-step Google Sheets guide on how to highlight or style the entire row when a checkbox is clicked.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.hongkiat.com\/blog\/google-sheets-click-highlight-row\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Highlight a Row in Google Sheets Based on a Checkbox\" \/>\n<meta property=\"og:description\" content=\"A step-by-step Google Sheets guide on how to highlight or style the entire row when a checkbox is clicked.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hongkiat.com\/blog\/google-sheets-click-highlight-row\/\" \/>\n<meta property=\"og:site_name\" content=\"Hongkiat\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hongkiatcom\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-11T13:01:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-click-highlight-row\/select-checkbox.jpg\" \/>\n<meta name=\"author\" content=\"Hongkiat Lim\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@hongkiat\" \/>\n<meta name=\"twitter:site\" content=\"@hongkiat\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hongkiat Lim\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-click-highlight-row\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-click-highlight-row\\\/\"},\"author\":{\"name\":\"Hongkiat Lim\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/e3613a3bf757e4f67770f0b7a339edd0\"},\"headline\":\"How to Highlight a Row in Google Sheets Based on a Checkbox\",\"datePublished\":\"2023-05-11T13:01:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-click-highlight-row\\\/\"},\"wordCount\":324,\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-click-highlight-row\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/google-sheets-click-highlight-row\\\/select-checkbox.jpg\",\"keywords\":[\"Google Sheets\"],\"articleSection\":[\"Internet\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-click-highlight-row\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-click-highlight-row\\\/\",\"name\":\"How to Highlight a Row in Google Sheets Based on a Checkbox - Hongkiat\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-click-highlight-row\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-click-highlight-row\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/google-sheets-click-highlight-row\\\/select-checkbox.jpg\",\"datePublished\":\"2023-05-11T13:01:58+00:00\",\"description\":\"A step-by-step Google Sheets guide on how to highlight or style the entire row when a checkbox is clicked.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-click-highlight-row\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-click-highlight-row\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-click-highlight-row\\\/#primaryimage\",\"url\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/google-sheets-click-highlight-row\\\/select-checkbox.jpg\",\"contentUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/google-sheets-click-highlight-row\\\/select-checkbox.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-click-highlight-row\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Highlight a Row in Google Sheets Based on a Checkbox\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\",\"name\":\"Hongkiat\",\"description\":\"Tech and Design Tips\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\",\"name\":\"Hongkiat.com\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/wp-content\\\/uploads\\\/hkdc-logo-rect-yoast.jpg\",\"contentUrl\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/wp-content\\\/uploads\\\/hkdc-logo-rect-yoast.jpg\",\"width\":1200,\"height\":799,\"caption\":\"Hongkiat.com\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hongkiatcom\",\"https:\\\/\\\/x.com\\\/hongkiat\",\"https:\\\/\\\/www.pinterest.com\\\/hongkiat\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/e3613a3bf757e4f67770f0b7a339edd0\",\"name\":\"Hongkiat Lim\",\"description\":\"Founder and Editor in Chief of Hongkiat.com. Hongkiat is also a designer, developer, entrepreneur, and an active investor in the US stock market.\",\"sameAs\":[\"http:\\\/\\\/www.hongkiat.com\\\/blog\"],\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/author\\\/hongkiat\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Highlight a Row in Google Sheets Based on a Checkbox - Hongkiat","description":"A step-by-step Google Sheets guide on how to highlight or style the entire row when a checkbox is clicked.","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:\/\/www.hongkiat.com\/blog\/google-sheets-click-highlight-row\/","og_locale":"en_US","og_type":"article","og_title":"How to Highlight a Row in Google Sheets Based on a Checkbox","og_description":"A step-by-step Google Sheets guide on how to highlight or style the entire row when a checkbox is clicked.","og_url":"https:\/\/www.hongkiat.com\/blog\/google-sheets-click-highlight-row\/","og_site_name":"Hongkiat","article_publisher":"https:\/\/www.facebook.com\/hongkiatcom","article_published_time":"2023-05-11T13:01:58+00:00","og_image":[{"url":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-click-highlight-row\/select-checkbox.jpg","type":"","width":"","height":""}],"author":"Hongkiat Lim","twitter_card":"summary_large_image","twitter_creator":"@hongkiat","twitter_site":"@hongkiat","twitter_misc":{"Written by":"Hongkiat Lim","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-click-highlight-row\/#article","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-click-highlight-row\/"},"author":{"name":"Hongkiat Lim","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/e3613a3bf757e4f67770f0b7a339edd0"},"headline":"How to Highlight a Row in Google Sheets Based on a Checkbox","datePublished":"2023-05-11T13:01:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-click-highlight-row\/"},"wordCount":324,"publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-click-highlight-row\/#primaryimage"},"thumbnailUrl":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-click-highlight-row\/select-checkbox.jpg","keywords":["Google Sheets"],"articleSection":["Internet"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-click-highlight-row\/","url":"https:\/\/www.hongkiat.com\/blog\/google-sheets-click-highlight-row\/","name":"How to Highlight a Row in Google Sheets Based on a Checkbox - Hongkiat","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-click-highlight-row\/#primaryimage"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-click-highlight-row\/#primaryimage"},"thumbnailUrl":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-click-highlight-row\/select-checkbox.jpg","datePublished":"2023-05-11T13:01:58+00:00","description":"A step-by-step Google Sheets guide on how to highlight or style the entire row when a checkbox is clicked.","breadcrumb":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-click-highlight-row\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hongkiat.com\/blog\/google-sheets-click-highlight-row\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-click-highlight-row\/#primaryimage","url":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-click-highlight-row\/select-checkbox.jpg","contentUrl":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-click-highlight-row\/select-checkbox.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-click-highlight-row\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.hongkiat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Highlight a Row in Google Sheets Based on a Checkbox"}]},{"@type":"WebSite","@id":"https:\/\/www.hongkiat.com\/blog\/#website","url":"https:\/\/www.hongkiat.com\/blog\/","name":"Hongkiat","description":"Tech and Design Tips","publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hongkiat.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.hongkiat.com\/blog\/#organization","name":"Hongkiat.com","url":"https:\/\/www.hongkiat.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.hongkiat.com\/blog\/wp-content\/uploads\/hkdc-logo-rect-yoast.jpg","contentUrl":"https:\/\/www.hongkiat.com\/blog\/wp-content\/uploads\/hkdc-logo-rect-yoast.jpg","width":1200,"height":799,"caption":"Hongkiat.com"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hongkiatcom","https:\/\/x.com\/hongkiat","https:\/\/www.pinterest.com\/hongkiat\/"]},{"@type":"Person","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/e3613a3bf757e4f67770f0b7a339edd0","name":"Hongkiat Lim","description":"Founder and Editor in Chief of Hongkiat.com. Hongkiat is also a designer, developer, entrepreneur, and an active investor in the US stock market.","sameAs":["http:\/\/www.hongkiat.com\/blog"],"url":"https:\/\/www.hongkiat.com\/blog\/author\/hongkiat\/"}]}},"jetpack_featured_media_url":"https:\/\/","jetpack_shortlink":"https:\/\/wp.me\/p4uxU-hpy","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/66932","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/comments?post=66932"}],"version-history":[{"count":3,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/66932\/revisions"}],"predecessor-version":[{"id":66935,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/66932\/revisions\/66935"}],"wp:attachment":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/media?parent=66932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/categories?post=66932"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/tags?post=66932"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/topic?post=66932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}