{"id":1416,"date":"2022-12-05T11:23:32","date_gmt":"2022-12-05T05:53:32","guid":{"rendered":"https:\/\/sheetstips.com\/?p=1416"},"modified":"2022-12-06T17:53:02","modified_gmt":"2022-12-06T12:23:02","slug":"automatically-add-colourful-stripes-in-your-google-sheets","status":"publish","type":"post","link":"https:\/\/sheetstips.com\/automatically-add-colourful-stripes-in-your-google-sheets\/","title":{"rendered":"How to Add ColourFul Stripes in Google Sheets? Cell Shading in Google Spreadsheet"},"content":{"rendered":"<p>We can apply the colour for the specific rows or columns with the help of the Conditional Formatting option available in the menu bar. The data is easier to read when the <strong><a href=\"https:\/\/sheetstips.com\/color-alternate-rows-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">alternate rows are coloured<\/a><\/strong>. These are also called zebra lines.<\/p>\n<p>The Conditional Formatting tool in Google Sheets allows you to format cells based on certain criteria, such as whether they contain a specific word or number.<\/p>\n<p>Also Read:<a href=\"https:\/\/btechgeeks.com\/python-program-to-find-sum-of-odd-numbers-using-recursion-in-a-list-array\/\" target=\"_blank\" rel=\"noopener\"> Python Program to Find Sum of Odd Numbers Using Recursion in a List\/Array<\/a><\/p>\n<p>In this article, let us understand how to add colourful stripes in google sheets with the help of <strong><a href=\"https:\/\/sheetstips.com\/google-sheets-tips\/\" target=\"_blank\" rel=\"noopener\">Google Sheet tips<\/a><\/strong>. 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=\"#How-to-Colour-Alternative-Rows-in-Google-Sheets?\">How to Colour Alternative Rows in Google Sheets?<\/a><\/li>\n<li><a href=\"#How-to-Colour-Alternative-Columns-in-Google-Sheets?\">How to Colour Alternative Columns in Google Sheets?<\/a><\/li>\n<li><a href=\"#How-to-Colour-Every-Third-in-Google-Sheets?\">How to Colour Every Third in Google Sheets?<\/a><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"How-to-Colour-Alternative-Rows-in-Google-Sheets?\">How to Colour Alternative Rows in Google Sheets?<\/h2>\n<p>We can colour alternative rows in google sheets with the help of the Conditional formatting tool. Below are the steps to colour alternative rows in google sheets,<\/p>\n<ul>\n<li><strong>Step-1<\/strong>: Select the cells in which you want to colour the rows<\/li>\n<li><strong>Step-2<\/strong>: Click on the Format tab and select the Conditional Formatting option from the toolbar<\/li>\n<li><strong>Step-3<\/strong>: Scroll down in the Format Rules box and Select &#8216;<strong>Custom Formula is<\/strong>&#8216; from the &#8216;<strong>Format cells if&#8217;<\/strong><\/li>\n<li><strong>Step-4<\/strong>: Enter the formula <span style=\"color: #ff0000;\"><strong>=ISEVEN(ROW())<\/strong><\/span> in the below field.<\/li>\n<li><strong>Step-5<\/strong>: Choose a formatting style to apply specific colours. You can either choose the default selection or use the toolbar below it to access other Fill colour possibilities.<\/li>\n<li><strong>Step-6<\/strong>: Click on Done to view the changes you have made.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1418 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/color-google-sheets.png\" alt=\"color google sheets\" width=\"974\" height=\"542\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/color-google-sheets.png 974w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/color-google-sheets-300x167.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/color-google-sheets-768x427.png 768w\" sizes=\"(max-width: 974px) 100vw, 974px\" \/><\/p>\n<p>In the above formula &#8211; <span style=\"color: #ff0000;\"><strong>=ISEVEN(ROW()), <\/strong><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><span style=\"color: #000000;\">It returns true for all cells with an even row number. This formula is checked in each cell through conditional formatting, and every cell that returns TRUE is filled with the given colour.<\/span><\/span><\/p>\n<ul>\n<li><a href=\"https:\/\/sheetstips.com\/color-alternate-rows-in-google-sheets\/\">How to Color Alternate Rows in Google Sheets: Alternating Colors Every 2 Rows, 3 Rows<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/highlight-duplicates-google-sheets\/\">How To Highlight Duplicates In Google Sheets?<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/remove-zero-values-from-a-google-spreadsheet\/\">How to Remove Zero Value from Google Spreadsheet? (3 Easy Methods)<\/a><\/li>\n<\/ul>\n<p>In order to colour the odd rows, then you could use formula &#8211; <span style=\"color: #ff0000;\"><strong>=ISODD(ROW())<\/strong><\/span><\/p>\n<h2 id=\"How-to-Colour-Alternative-Columns-in-Google-Sheets?\">How to Colour Alternative Columns in Google Sheets?<\/h2>\n<p>We can colour alternative columns in google sheets with the help of the Conditional formatting tool. Below are the steps to colour alternative columns in google sheets,<\/p>\n<ul>\n<li><strong>Step-1<\/strong>: Select the cells in which you want to colour the columns.<\/li>\n<li><strong>Step-2<\/strong>: Click on the Format and select the Conditional Formatting option from the toolbar<\/li>\n<li><strong>Step-3<\/strong>: Scroll down in the Format Rules box and Select &#8216;<strong>Custom Formula is<\/strong>&#8216; from the &#8216;<strong>Format cells if<\/strong>&#8216;<\/li>\n<li><strong>Step-4:<\/strong> Enter the formula <span style=\"color: #ff0000;\"><strong>=ISEVEN(COLUMN())<\/strong><\/span> in the below field.<\/li>\n<li><strong>Step-5<\/strong>: Choose a formatting style to apply specific colours. You can either choose the default selection or use the toolbar below it to access other Fill colour possibilities.<\/li>\n<li><strong>Step-6<\/strong>: Click on Done to view the changes you have made.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1419 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/color-google-sheets1.png\" alt=\"color google sheets\" width=\"961\" height=\"545\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/color-google-sheets1.png 961w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/color-google-sheets1-300x170.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/color-google-sheets1-768x436.png 768w\" sizes=\"(max-width: 961px) 100vw, 961px\" \/><\/p>\n<p>In the above formula &#8211; <span style=\"color: #ff0000;\"><strong>=ISEVEN(COLUMN()), <\/strong><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><span style=\"color: #000000;\">It returns true for all cells with an even column number. This formula is checked in each cell through conditional formatting, and every cell that returns TRUE is filled with the given colour.<\/span><\/span><\/p>\n<p>In order to colour the odd column, then you could use formula &#8211; <span style=\"color: #ff0000;\"><strong>=ISODD(COLUMN())<\/strong><\/span><\/p>\n<h2 id=\"How-to-Colour-Every-Third-in-Google-Sheets?\">How to Colour Every Third in Google Sheets?<\/h2>\n<p>Let us understand how to colour every third row or column with the formula below,<\/p>\n<ul>\n<li><span class=\" default-formula-text-color\" dir=\"auto\">For colouring every third row, use the formula <strong>=<\/strong><\/span><strong><span class=\" default-formula-text-color\" dir=\"auto\">MOD<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(ROW<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\"number\" dir=\"auto\">3<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\"number\" dir=\"auto\">0<\/span><\/strong><\/li>\n<li>For colouring every third column, use the formula <span class=\" default-formula-text-color\" dir=\"auto\"><strong>=<\/strong><\/span><strong><span class=\" default-formula-text-color\" dir=\"auto\">MOD<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(COLUMN<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\"number\" dir=\"auto\">3<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\"number\" dir=\"auto\">0<\/span><\/strong><\/li>\n<\/ul>\n<p>Below are the steps to colour every third row,<\/p>\n<ul>\n<li><strong>Step-1<\/strong>: Select the cells in which you want to colour the rows<\/li>\n<li><strong>Step-2<\/strong>: Click on the Format and select the Conditional Formatting option from the toolbar<\/li>\n<li><strong>Step-3<\/strong>: Scroll down in the Format Rules box and Select &#8216;Custom Formula is&#8217; from the &#8216;Format cells if&#8217;<\/li>\n<li><strong>Step-4<\/strong>: Enter the formula <span style=\"color: #ff0000;\"><span class=\" default-formula-text-color\" dir=\"auto\"><strong>=<\/strong><\/span><strong><span class=\" default-formula-text-color\" dir=\"auto\">MOD<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(ROW<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\"number\" dir=\"auto\">3<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\"number\" dir=\"auto\">0 <\/span><\/strong><\/span>\u00a0in the below field.<\/li>\n<li><strong>Step-5<\/strong>: Choose a formatting style to apply specific colours. You can either choose the default selection or use the toolbar below it to access other Fill colour possibilities.<\/li>\n<li><strong>Step-6<\/strong>: Click on Done to view the changes you have made.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1420 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/color-google-sheets2.png\" alt=\"color google sheets\" width=\"961\" height=\"541\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/color-google-sheets2.png 961w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/color-google-sheets2-300x169.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/color-google-sheets2-768x432.png 768w\" sizes=\"(max-width: 961px) 100vw, 961px\" \/><\/p>\n<p>The formula <strong><span style=\"color: #ff0000;\">=MOD(ROW(),3)=0<\/span><\/strong> returns TRUE for all cells that return 0 as the remainder, and that cell is highlighted with the given colour.<\/p>\n<p>You may use the same logic to every fourth, fifth, sixth, and so on row.<\/p>\n<p>Similarly, you can use the formula <strong><span style=\"color: #ff0000;\">=MOD(COLUMN(),3)=0 <\/span><\/strong><span style=\"color: #000000;\">for colouring every third column in google sheets.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We can apply the colour for the specific rows or columns with the help of the Conditional Formatting option available in the menu bar. The data is easier to read when the alternate rows are coloured. These are also called zebra lines. The Conditional Formatting tool in Google Sheets allows you to format cells based &#8230; <a title=\"How to Add ColourFul Stripes in Google Sheets? Cell Shading in Google Spreadsheet\" class=\"read-more\" href=\"https:\/\/sheetstips.com\/automatically-add-colourful-stripes-in-your-google-sheets\/\" aria-label=\"More on How to Add ColourFul Stripes in Google Sheets? Cell Shading in Google Spreadsheet\">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":[{"id":573,"url":"https:\/\/sheetstips.com\/conditional-formatting-google-sheets\/","url_meta":{"origin":1416,"position":0},"title":"The Ultimate Guide to Using Conditional Formatting in Google Sheets","author":"Varsha","date":"May 18, 2022","format":false,"excerpt":"Conditional Formatting in Google Sheets allows you to highlight cells that meet certain criteria. This can help you better understand spreadsheets at a glance and create spreadsheets that make them more human-readable. It's also a great way to track goals, providing visual indicators of how you're doing against specific metrics.\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"conditional formatting","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/07\/highlight-duplicates-in-google-sheet.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":802,"url":"https:\/\/sheetstips.com\/heat-map-google-sheets\/","url_meta":{"origin":1416,"position":1},"title":"How to Create and Use Heat Map in Google Sheets With Examples","author":"Varsha","date":"May 17, 2022","format":false,"excerpt":"Google Sheets Heatmaps are a quick and easy way to display and discover anomalies in data, and Google Sheets makes it simple to do so. We can change the color of a cell based on its value using the Google Sheets Conditional Formatting function. In this article, let's understand everything\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"heatmaps in google sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/09\/heatmap-in-google-sheets2-1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":214,"url":"https:\/\/sheetstips.com\/color-alternate-rows-in-google-sheets\/","url_meta":{"origin":1416,"position":2},"title":"How to Color Alternate Rows in Google Sheets: Alternating Colors Every 2 Rows, 3 Rows","author":"Varsha","date":"July 21, 2022","format":false,"excerpt":"Alternating Colors in Google Sheets: The Google Spreadsheets are adding new features from day to day to work efficiently. Sadly, we didn't have the option to colour the alternate rows, so we had to rely on the Conditional Formatting function in Google Sheets to do so. However, the latest feature\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"remove alternating colors","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/07\/remove-alternating-colors.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":4599,"url":"https:\/\/sheetstips.com\/how-to-compare-two-sheets-in-google-sheets\/","url_meta":{"origin":1416,"position":3},"title":"How To Compare Two Sheets in Google Sheets? | Compare 2 Google Sheets","author":"Bhagya","date":"December 4, 2022","format":false,"excerpt":"Google Sheets Compare Data in Two Sheets: We all enjoy comparing things to buy, try, decide, etc., just to get a side-by-side view of the key features of everything. But, did you know you could do that with Google Sheets too? Smaller sheets are easier to work with, but for\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/08\/duplicate-step-2-201x300.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":16,"url":"https:\/\/sheetstips.com\/highlight-duplicates-google-sheets\/","url_meta":{"origin":1416,"position":4},"title":"How To Highlight Duplicates In Google Sheets?","author":"Varsha","date":"May 20, 2022","format":false,"excerpt":"Highlighting Duplicates in Google Sheets: When you're working on a Google sheet that has numerous duplicate entries, then it would be difficult for you to sort duplicates entries. Manually finding the duplicates and deleting the entries one by one is a time-consuming process. Thus to overcome this, one can make\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/07\/row-duplicates-entires-in-google-sheet.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":688,"url":"https:\/\/sheetstips.com\/search-in-google-sheets\/","url_meta":{"origin":1416,"position":5},"title":"How to Search in Google Sheets and Highlight Matching Data? (4 Easy Methods)","author":"Varsha","date":"May 17, 2022","format":false,"excerpt":"Search is the most important feature which anyone would like to use when working with a huge dataset. Google Sheets is known for storing and organizing data and that is the reason we tend to use the Search feature. However, if you don't how to make use of Search Feature\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"search-in-google-sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/08\/search-in-google-sheets.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/1416"}],"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=1416"}],"version-history":[{"count":8,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/1416\/revisions"}],"predecessor-version":[{"id":4892,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/1416\/revisions\/4892"}],"wp:attachment":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media?parent=1416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/categories?post=1416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/tags?post=1416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}