How do I add a pattern to a cell in Excel?

Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Changing Cell Patterns.

by Allen Wyatt
(last updated July 21, 2021)

Excel allows you to easily change the background pattern used in the cell. In the early days of spreadsheets, patterns were the only way you had to differentiate one cell from another. To change cell patterns, follow these steps:

1. Select the cells whose background patterns you want to change.
2. Choose Cells from the Format menu. Excel displays the Format Cells dialog box.
3. Make sure you have the Patterns tab selected. (See Figure 1.)

Figure 1. The Patterns tab of the Format Cells dialog box.

4. Use the Pattern drop-down list to select any of the available patterns.
5. Click on OK.

You should note that any pattern you select appears in the background of the cell, meaning that it appears behind any information contained within the cell. Thus, by creatively combining patterns, pattern colors, and other formatting options, you can create many, many different special effects.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2763) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Changing Cell Patterns.

Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!

Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Changing Cell Patterns.

by Allen Wyatt
(last updated July 24, 2021)

Excel allows you to easily change the background pattern used in the cell. In the early days of spreadsheets, patterns were the only way you had to differentiate one cell from another. To change cell patterns, follow these steps:

1. Select the cells whose background patterns you want to change.
2. Display the Home tab of the ribbon.
3. Click the Format tool in the Cells group, and then click Format Cells. Excel displays the Format Cells dialog box.
4. Make sure the Fill tab is displayed. (See Figure 1.)

Figure 1. The Fill tab of the Format Cells dialog box.

5. Use the Pattern Color drop-down list to select the color you want used for the pattern.
6. Use the Pattern Style drop-down list to select any of the available patterns.
7. Click on OK.

You should note that any pattern you select appears in the background of the cell, meaning that it appears behind any information contained within the cell. Thus, by creatively combining patterns, pattern colors, and other formatting options, you can create many, many different special effects.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6286) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365. You can find a version of this tip for the older menu interface of Excel here: Changing Cell Patterns.

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

{"appState":{"pageLoadApiCallsStatus":true},"articleState":{"article":{"headers":{"creationTime":"2016-03-26T21:04:45+00:00","modifiedTime":"2016-03-26T21:04:45+00:00","timestamp":"2022-02-24T16:56:56+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"//dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"//dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"//dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"Excel","_links":{"self":"//dummies-api.dummies.com/v2/categories/33644"},"slug":"excel","categoryId":33644}],"title":"How to Apply Fill Colors, Patterns, and Gradients to Cells in Excel 2010","strippedTitle":"how to apply fill colors, patterns, and gradients to cells in excel 2010","slug":"how-to-apply-fill-colors-patterns-and-gradients-to-cells-in-excel-2010","canonicalUrl":"","seo":{"metaDescription":"","noIndex":0,"noFollow":0},"content":"<p>You can add emphasis to selected cells in an Excel 2010 worksheet by changing the fill color or applying a pattern or gradient effect to the cells. If you're using a black-and-white printer, restrict your color choices to light gray in the color palette and use a simple pattern for cells that contain text so that the text remains legible.</p>\n<h2 id=\"tab1\" >Applying a fill color</h2>\n<p>To choose a new fill color for a cell selection, follow these steps:</p>\n<ol class=\"level-one\">\n <li><p class=\"first-para\">On the Home tab, in the Font group, click the Fill Color button's drop-down menu.</p>\n<p class=\"child-para\">The Fill Color palette appears.</p>\n<div class=\"imageBlock\" style=\"width:535px;\"><img src=\"//sg.cdnki.com/how-do-i-add-a-pattern-to-a-cell-in-excel---aHR0cHM6Ly93d3cuZHVtbWllcy5jb20vd3AtY29udGVudC91cGxvYWRzLzIyMTM0Ny5pbWFnZTAuanBn.webp\" width=\"535\" height=\"400\" alt=\"Use the Fill Color button to choose a solid background color to add to selected cells.\"/><div class=\"imageCaption\">Use the Fill Color button to choose a solid background color to add to selected cells.</div></div>\n </li>\n <li><p class=\"first-para\">Select the color you want to use in the drop-down palette.</p>\n<p class=\"child-para\">Excel's Live Preview lets you see what the cell selection looks like in a particular fill color when you move the mouse pointer over the color swatches before you click the desired color.</p>\n </li>\n</ol>\n<h2 id=\"tab2\" >Adding patterns to cells</h2>\n<p>Follow these steps to choose a pattern for a cell selection:</p>\n<ol class=\"level-one\">\n <li><p class=\"first-para\">Click the Font dialog box launcher on the Home tab (or press Ctrl+1).</p>\n<p class=\"child-para\">The Font dialog box launcher is the small icon in the bottom-right corner of the Font group. The Format Cells dialog box appears.</p>\n </li>\n <li><p class=\"first-para\">Click the Fill tab.</p>\n<div class=\"imageBlock\" style=\"width:445px;\"><img src=\"//sg.cdnki.com/how-do-i-add-a-pattern-to-a-cell-in-excel---aHR0cHM6Ly93d3cuZHVtbWllcy5jb20vd3AtY29udGVudC91cGxvYWRzLzIyMTM0OC5pbWFnZTEuanBn.webp\" width=\"445\" height=\"400\" alt=\"Select a new pattern for a cell selection on the Fill tab of the Format Cells dialog box.\"/><div class=\"imageCaption\">Select a new pattern for a cell selection on the Fill tab of the Format Cells dialog box.</div></div>\n </li>\n <li><p class=\"first-para\">Click a pattern swatch from the Pattern Style button's drop-down menu.</p>\n </li>\n <li><p class=\"first-para\">Click a pattern color from the Pattern Color button's drop-down palette.</p>\n<p class=\"child-para\">The Sample box displays the selected pattern and color.</p>\n </li>\n <li><p class=\"first-para\">(Optional) To add a fill color to the background of the pattern, click its color swatch in the Background Color section.</p>\n </li>\n <li><p class=\"first-para\">Click OK.</p>\n </li>\n</ol>\n<h2 id=\"tab3\" >Applying a gradient effect</h2>\n<p>To add a gradient effect to a cell selection, follow these steps:</p>\n<ol class=\"level-one\">\n <li><p class=\"first-para\">Press Ctrl+1 to open the Format Cells dialog box and then click the Fill tab.</p>\n </li>\n <li><p class=\"first-para\">Click the Fill Effects button.</p>\n<p class=\"child-para\">The Fill Effects dialog box appears, with controls that enable you to define the two colors to use, as well as shading style and variant.</p>\n<div class=\"imageBlock\" style=\"width:338px;\"><img src=\"//sg.cdnki.com/how-do-i-add-a-pattern-to-a-cell-in-excel---aHR0cHM6Ly93d3cuZHVtbWllcy5jb20vd3AtY29udGVudC91cGxvYWRzLzIyMTM0OS5pbWFnZTIuanBn.webp\" width=\"338\" height=\"400\" alt=\"Use the Fill Effects dialog box to apply a gradient effect to selected cells.\"/><div class=\"imageCaption\">Use the Fill Effects dialog box to apply a gradient effect to selected cells.</div></div>\n </li>\n <li><p class=\"first-para\">Select the two colors you want to use in the Colors section.</p>\n </li>\n <li><p class=\"first-para\">Select one of the Shading Styles options to choose the type of gradient pattern you want to use; then click the variant that you want to use.</p>\n<p class=\"child-para\">The Sample box displays the current selections.</p>\n </li>\n <li><p class=\"first-para\">Click OK two times to close both dialog boxes.</p>\n </li>\n</ol>\n<p class=\"Remember\">You can remove fill colors, patterns, and gradients assigned to a cell selection by clicking the No Fill option on the Fill Color button's drop-down menu on the Home tab.</p>","description":"<p>You can add emphasis to selected cells in an Excel 2010 worksheet by changing the fill color or applying a pattern or gradient effect to the cells. If you're using a black-and-white printer, restrict your color choices to light gray in the color palette and use a simple pattern for cells that contain text so that the text remains legible.</p>\n<h2 id=\"tab1\" >Applying a fill color</h2>\n<p>To choose a new fill color for a cell selection, follow these steps:</p>\n<ol class=\"level-one\">\n <li><p class=\"first-para\">On the Home tab, in the Font group, click the Fill Color button's drop-down menu.</p>\n<p class=\"child-para\">The Fill Color palette appears.</p>\n<div class=\"imageBlock\" style=\"width:535px;\"><img src=\"//www.dummies.com/wp-content/uploads/221347.image0.jpg\" width=\"535\" height=\"400\" alt=\"Use the Fill Color button to choose a solid background color to add to selected cells.\"/><div class=\"imageCaption\">Use the Fill Color button to choose a solid background color to add to selected cells.</div></div>\n </li>\n <li><p class=\"first-para\">Select the color you want to use in the drop-down palette.</p>\n<p class=\"child-para\">Excel's Live Preview lets you see what the cell selection looks like in a particular fill color when you move the mouse pointer over the color swatches before you click the desired color.</p>\n </li>\n</ol>\n<h2 id=\"tab2\" >Adding patterns to cells</h2>\n<p>Follow these steps to choose a pattern for a cell selection:</p>\n<ol class=\"level-one\">\n <li><p class=\"first-para\">Click the Font dialog box launcher on the Home tab (or press Ctrl+1).</p>\n<p class=\"child-para\">The Font dialog box launcher is the small icon in the bottom-right corner of the Font group. The Format Cells dialog box appears.</p>\n </li>\n <li><p class=\"first-para\">Click the Fill tab.</p>\n<div class=\"imageBlock\" style=\"width:445px;\"><img src=\"//www.dummies.com/wp-content/uploads/221348.image1.jpg\" width=\"445\" height=\"400\" alt=\"Select a new pattern for a cell selection on the Fill tab of the Format Cells dialog box.\"/><div class=\"imageCaption\">Select a new pattern for a cell selection on the Fill tab of the Format Cells dialog box.</div></div>\n </li>\n <li><p class=\"first-para\">Click a pattern swatch from the Pattern Style button's drop-down menu.</p>\n </li>\n <li><p class=\"first-para\">Click a pattern color from the Pattern Color button's drop-down palette.</p>\n<p class=\"child-para\">The Sample box displays the selected pattern and color.</p>\n </li>\n <li><p class=\"first-para\">(Optional) To add a fill color to the background of the pattern, click its color swatch in the Background Color section.</p>\n </li>\n <li><p class=\"first-para\">Click OK.</p>\n </li>\n</ol>\n<h2 id=\"tab3\" >Applying a gradient effect</h2>\n<p>To add a gradient effect to a cell selection, follow these steps:</p>\n<ol class=\"level-one\">\n <li><p class=\"first-para\">Press Ctrl+1 to open the Format Cells dialog box and then click the Fill tab.</p>\n </li>\n <li><p class=\"first-para\">Click the Fill Effects button.</p>\n<p class=\"child-para\">The Fill Effects dialog box appears, with controls that enable you to define the two colors to use, as well as shading style and variant.</p>\n<div class=\"imageBlock\" style=\"width:338px;\"><img src=\"//www.dummies.com/wp-content/uploads/221349.image2.jpg\" width=\"338\" height=\"400\" alt=\"Use the Fill Effects dialog box to apply a gradient effect to selected cells.\"/><div class=\"imageCaption\">Use the Fill Effects dialog box to apply a gradient effect to selected cells.</div></div>\n </li>\n <li><p class=\"first-para\">Select the two colors you want to use in the Colors section.</p>\n </li>\n <li><p class=\"first-para\">Select one of the Shading Styles options to choose the type of gradient pattern you want to use; then click the variant that you want to use.</p>\n<p class=\"child-para\">The Sample box displays the current selections.</p>\n </li>\n <li><p class=\"first-para\">Click OK two times to close both dialog boxes.</p>\n </li>\n</ol>\n<p class=\"Remember\">You can remove fill colors, patterns, and gradients assigned to a cell selection by clicking the No Fill option on the Fill Color button's drop-down menu on the Home tab.</p>","blurb":"","authors":[{"authorId":9027,"name":"Greg Harvey","slug":"greg-harvey","description":"Greg Harvey, PhD, was president of Mind Over Media and a highly skilled instructor. He wrote computer books for more than 20 years, and his long list of best sellers included all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies. He died in 2020.","_links":{"self":"//dummies-api.dummies.com/v2/authors/9027"}}],"primaryCategoryTaxonomy":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"//dummies-api.dummies.com/v2/categories/33644"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[{"label":"Applying a fill color","target":"#tab1"},{"label":"Adding patterns to cells","target":"#tab2"},{"label":"Applying a gradient effect","target":"#tab3"}],"relatedArticles":{"fromBook":[{"articleId":209119,"title":"Excel 2010 For Dummies Cheat Sheet","slug":"excel-2010-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/209119"}},{"articleId":206078,"title":"How to Save an Excel 2010 Workbook as a PDF or XPS File","slug":"how-to-save-an-excel-2010-workbook-as-a-pdf-or-xps-file","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/206078"}},{"articleId":206070,"title":"How to Rename an Excel 2010 Worksheet","slug":"how-to-rename-an-excel-2010-worksheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/206070"}},{"articleId":206064,"title":"How to Drag and Drop Data in Excel 2010","slug":"how-to-drag-and-drop-data-in-excel-2010","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/206064"}},{"articleId":206061,"title":"Automatically Fix Typos and Add Text with AutoCorrect in Excel 2010","slug":"automatically-fix-typos-and-add-text-with-autocorrect-in-excel-2010","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/206061"}}],"fromCategory":[{"articleId":288828,"title":"Excel 2021 All-in-One For Dummies Cheat Sheet","slug":"excel-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/288828"}},{"articleId":265521,"title":"How to Use the XLOOKUP Function in Excel 2016","slug":"how-to-use-the-xlookup-function-in-excel-2016","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/265521"}},{"articleId":263475,"title":"Notes and File Sharing features in Excel 2016 Update","slug":"notes-and-coauthoring-features-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/263475"}},{"articleId":263466,"title":"New Chart & Graphics features on Excel 2016 update","slug":"new-chart-graphics-features-on-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/263466"}},{"articleId":263453,"title":"New Formulas and Functions in Excel 2016","slug":"how-to-use-new-formula-and-functions-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/263453"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281702,"slug":"excel-2010-for-dummies","isbn":"9780470489536","categoryList":["technology","software","microsoft-products","excel"],"amazon":{"default":"//www.amazon.com/gp/product/0470489537/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"//www.amazon.ca/gp/product/0470489537/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"//www.tkqlhce.com/click-9208661-13710633?url=//www.chapters.indigo.ca/en-ca/books/product/0470489537-item.html&cjsku=978111945484","gb":"//www.amazon.co.uk/gp/product/0470489537/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"//www.amazon.de/gp/product/0470489537/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"//www.dummies.com/wp-content/uploads/excel-2010-for-dummies-cover-9780470489536-203x255.jpg","width":203,"height":255},"title":"Excel 2010 For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"\n <p><b data-author-id=\"9027\">Greg Harvey, PhD,</b> is president of Mind Over Media, Inc. He is the author of all editions of <i>Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies</i>, and <i>Windows For Dummies Quick Reference</i>. He's also an experienced educator. </p>","authors":[{"authorId":9027,"name":"Greg Harvey","slug":"greg-harvey","description":"Greg Harvey, PhD, was president of Mind Over Media and a highly skilled instructor. He wrote computer books for more than 20 years, and his long list of best sellers included all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies. He died in 2020.","_links":{"self":"//dummies-api.dummies.com/v2/authors/9027"}}],"_links":{"self":"//dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;excel&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9780470489536&quot;]}]\" id=\"du-slot-6217b8d8ce632\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;excel&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9780470489536&quot;]}]\" id=\"du-slot-6217b8d8cefee\"></div></div>"},"articleType":{"articleType":"Articles","articleList":null,"content":null,"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":null,"lifeExpectancySetFrom":null,"dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":190851},"articleLoadedStatus":"success"},"listState":{"list":{},"objectTitle":"","status":"initial","pageType":null,"objectId":null,"page":1,"sortField":"time","sortOrder":1,"categoriesIds":[],"articleTypes":[],"filterData":{},"filterDataLoadedStatus":"initial","pageSize":10},"adsState":{"pageScripts":{"headers":{"timestamp":"2022-06-10T12:59:10+00:00"},"adsId":0,"data":{"scripts":[{"pages":["all"],"location":"header","script":"<!--Optimizely Script-->\r\n<script src=\"//cdn.optimizely.com/js/10563184655.js\"></script>","enabled":false},{"pages":["all"],"location":"header","script":"<!-- comScore Tag -->\r\n<script>var _comscore = _comscore || [];_comscore.push({ c1: \"2\", c2: \"15097263\" });(function() {var s = document.createElement(\"script\"), el = document.getElementsByTagName(\"script\")[0]; s.async = true;s.src = (document.location.protocol == \"\" ? \"//sb\" : \"//b\") + \".scorecardresearch.com/beacon.js\";el.parentNode.insertBefore(s, el);})();</script><noscript><img src=\"//sb.scorecardresearch.com/p?c1=2&c2=15097263&cv=2.0&cj=1\" /></noscript>\r\n<!-- / comScore Tag -->","enabled":true},{"pages":["all"],"location":"footer","script":"<!--BEGIN QUALTRICS WEBSITE FEEDBACK SNIPPET-->\r\n<script type='text/javascript'>\r\n(function(){var g=function(e,h,f,g){\r\nthis.get=function(a){for(var a=a+\"=\",c=document.cookie.split(\";\"),b=0,e=c.length;b<e;b++){for(var d=c[b];\" \"==d.charAt(0);)d=d.substring(1,d.length);if(0==d.indexOf(a))return d.substring(a.length,d.length)}return null};\r\nthis.set=function(a,c){var b=\"\",b=new Date;b.setTime(b.getTime()+6048E5);b=\"; expires=\"+b.toGMTString();document.cookie=a+\"=\"+c+b+\"; path=/; \"};\r\nthis.check=function(){var a=this.get(f);if(a)a=a.split(\":\");else if(100!=e)\"v\"==h&&(e=Math.random()>=e/100?0:100),a=[h,e,0],this.set(f,a.join(\":\"));else return!0;var c=a[1];if(100==c)return!0;switch(a[0]){case \"v\":return!1;case \"r\":return c=a[2]%Math.floor(100/c),a[2]++,this.set(f,a.join(\":\")),!c}return!0};\r\nthis.go=function(){if(this.check()){var a=document.createElement(\"script\");a.type=\"text/javascript\";a.src=g;document.body&&document.body.appendChild(a)}};\r\nthis.start=function(){var t=this;\"complete\"!==document.readyState?window.addEventListener?window.addEventListener(\"load\",function(){t.go()},!1):window.attachEvent&&window.attachEvent(\"onload\",function(){t.go()}):t.go()};};\r\ntry{(new g(100,\"r\",\"QSI_S_ZN_5o5yqpvMVjgDOuN\",\"//zn5o5yqpvmvjgdoun-wiley.siteintercept.qualtrics.com/SIE/?Q_ZID=ZN_5o5yqpvMVjgDOuN\")).start()}catch(i){}})();\r\n</script><div id='ZN_5o5yqpvMVjgDOuN'><!--DO NOT REMOVE-CONTENTS PLACED HERE--></div>\r\n<!--END WEBSITE FEEDBACK SNIPPET-->","enabled":false},{"pages":["all"],"location":"header","script":"<!-- Hotjar Tracking Code for //www.dummies.com -->\r\n<script>\r\n (function(h,o,t,j,a,r){\r\n h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)};\r\n h._hjSettings={hjid:257151,hjsv:6};\r\n a=o.getElementsByTagName('head')[0];\r\n r=o.createElement('script');r.async=1;\r\n r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv;\r\n a.appendChild(r);\r\n })(window,document,'//static.hotjar.com/c/hotjar-','.js?sv=');\r\n</script>","enabled":false},{"pages":["article"],"location":"header","script":"<!-- //Connect Container: dummies --> <script src=\"//get.s-onetag.com/bffe21a1-6bb8-4928-9449-7beadb468dae/tag.min.js\" async defer></script>","enabled":true},{"pages":["homepage"],"location":"header","script":"<meta name=\"facebook-domain-verification\" content=\"irk8y0irxf718trg3uwwuexg6xpva0\" />","enabled":true},{"pages":["homepage","article","category","search"],"location":"footer","script":"<!-- Facebook Pixel Code -->\r\n<noscript>\r\n<img height=\"1\" width=\"1\" src=\"//www.facebook.com/tr?id=256338321977984&ev=PageView&noscript=1\"/>\r\n</noscript>\r\n<!-- End Facebook Pixel Code -->","enabled":true}]}},"pageScriptsLoadedStatus":"success"},"navigationState":{"navigationCollections":[{"collectionId":287568,"title":"BYOB (Be Your Own Boss)","hasSubCategories":false,"url":"/collection/for-the-entry-level-entrepreneur-287568"},{"collectionId":293237,"title":"Be a Rad Dad","hasSubCategories":false,"url":"/collection/be-the-best-dad-293237"},{"collectionId":287563,"title":"For Those Seeking Peace of Mind","hasSubCategories":false,"url":"/collection/for-those-seeking-peace-of-mind-287563"},{"collectionId":287570,"title":"For the Aspiring Aficionado","hasSubCategories":false,"url":"/collection/for-the-bougielicious-287570"},{"collectionId":291903,"title":"For the Budding Cannabis Enthusiast","hasSubCategories":false,"url":"/collection/for-the-budding-cannabis-enthusiast-291903"},{"collectionId":291934,"title":"For the Exam-Season Crammer","hasSubCategories":false,"url":"/collection/for-the-exam-season-crammer-291934"},{"collectionId":287569,"title":"For the Hopeless Romantic","hasSubCategories":false,"url":"/collection/for-the-hopeless-romantic-287569"},{"collectionId":287567,"title":"For the Unabashed Hippie","hasSubCategories":false,"url":"/collection/for-the-unabashed-hippie-287567"},{"collectionId":292186,"title":"Just DIY It","hasSubCategories":false,"url":"/collection/just-diy-it-292186"},{"collectionId":290164,"title":"Make a Commitment to Better Yourself","hasSubCategories":false,"url":"/collection/make-a-commitment-to-better-yourself-290164"}],"navigationCollectionsLoadedStatus":"success","navigationCategories":{"books":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/books/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/books/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/books/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/books/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/books/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/books/level-0-category-0"}},"articles":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/articles/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/articles/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/articles/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/articles/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/articles/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/articles/level-0-category-0"}}},"navigationCategoriesLoadedStatus":"success"},"searchState":{"searchList":[],"searchStatus":"initial","relatedArticlesList":[],"relatedArticlesStatus":"initial"},"routeState":{"name":"Article4","path":"/article/technology/software/microsoft-products/excel/how-to-apply-fill-colors-patterns-and-gradients-to-cells-in-excel-2010-190851/","hash":"","query":{},"params":{"category1":"technology","category2":"software","category3":"microsoft-products","category4":"excel","article":"how-to-apply-fill-colors-patterns-and-gradients-to-cells-in-excel-2010-190851"},"fullPath":"/article/technology/software/microsoft-products/excel/how-to-apply-fill-colors-patterns-and-gradients-to-cells-in-excel-2010-190851/","meta":{"routeType":"article","breadcrumbInfo":{"suffix":"Articles","baseRoute":"/category/articles"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"dropsState":{"submitEmailResponse":false,"status":"initial"},"sfmcState":{"newsletterSignupStatus":"initial"}}