{"id":415451,"date":"2022-03-11T19:00:00","date_gmt":"2022-03-11T16:00:00","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-copy-conditional-formatting-in-microsoft-excel\/"},"modified":"2022-03-11T19:00:00","modified_gmt":"2022-03-11T16:00:00","slug":"how-to-copy-conditional-formatting-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-copy-conditional-formatting-in-microsoft-excel\/","title":{"rendered":"#How to Copy Conditional Formatting in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a289f04d56b7\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a289f04d56b7\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-copy-conditional-formatting-in-microsoft-excel\/#%E2%80%9CHow_to_Copy_Conditional_Formatting_in_Microsoft_Excel%E2%80%9D\" >&#8220;How to Copy Conditional Formatting in Microsoft Excel&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-copy-conditional-formatting-in-microsoft-excel\/#Copy_Formatting_Using_Format_Painter\" >Copy Formatting Using Format Painter<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-copy-conditional-formatting-in-microsoft-excel\/#Copy_Formatting_Using_Paste_Special\" >Copy Formatting Using Paste Special<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-copy-conditional-formatting-in-microsoft-excel\/#Copy_Formatting_Using_the_Conditional_Formatting_Rules_Manager\" >Copy Formatting Using the Conditional Formatting Rules Manager<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Copy_Conditional_Formatting_in_Microsoft_Excel%E2%80%9D\"><\/span>&#8220;How to Copy Conditional Formatting in Microsoft Excel&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<!-- UNCACHED CONTENT --><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you use conditional formatting in Microsoft Excel to automatically format cells that match criteria, you may want to <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ly the same rule to another part of your sheet or workbook. Instead of creating a new rule, just copy it.<\/p>\n<p>You might have a conditional formatting rule based on date that you want to use for other dates. Or, you may have a rule for finding duplicates and need to use it on another sheet. We\u2019ll show you three ways to copy conditional formatting in Excel and use it elsewhere in your spreadsheet or in another sheet in the same workbook.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Copy_Formatting_Using_Format_Painter\"><\/span>Copy Formatting Using Format Painter<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/howto\/14165\/copy-excel-formatting-the-easy-way-with-format-painter\/\">Format Painter is a helpful Office tool that lets you copy formatting to other parts of your document. With it, you can copy a conditional formatting rule to other cells.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>Copy Excel Formatting the Easy Way with Format Painter<\/em><\/strong><\/p>\n<p>Select the cells containing the conditional formatting rule.\u00a0Go to the Home tab and click the Format Painter button in the Clipboard section of the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-788666\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/HomeFormatPainter-ExcelCopyConditionalFormatting.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Format Painter on the Home tab\" width=\"408\" height=\"379\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll see your cursor change to a plus sign with a paint brush. Select the cells you want to apply the same rule to, making sure to drag through adjacent cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-788665\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/UseFormatPainter-ExcelCopyConditionalFormatting.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Using the Painter to copy the formatting rule\" width=\"580\" height=\"176\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Now you\u2019ve copied the conditional formatting rule, not just the formatting. You can confirm this by viewing the Conditional Formatting Rules Manager using Home &gt; Conditional Formatting &gt; Manage Rules.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-788664\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/ConfirmFormatPainter-ExcelCopyConditionalFormatting.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Confirm the rule in the Manager\" width=\"650\" height=\"207\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Copy_Formatting_Using_Paste_Special\"><\/span>Copy Formatting Using Paste Special<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The Paste Special options in Excel can do more than help you <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/745730\/how-to-add-subtract-or-multiply-values-with-paste-special-in-microsoft-excel\/\">add or multiply values. You can use the formatting paste action to apply conditional formatting too.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Add or Multiply Values with Paste Special in Microsoft Excel<\/em><\/strong><\/p>\n<p>Select the cells containing the conditional formatting rule. Then copy them using one of these methods:<\/p>\n<ul>\n<li>Right-click and select \u201cCopy.\u201d<\/li>\n<li>Click the Copy button in the Clipboard section of the ribbon on the Home tab.<\/li>\n<li>Use the keyboard shortcut Ctrl+C on Windows or Command+C on Mac.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-788669\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/HomeCopy-ExcelCopyConditionalFormatting.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Copy the formatted cells\" width=\"430\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Select the cells that you want to apply the rule to by dragging through them. Then use the Paste Special action for formatting with one of the following.<\/p>\n<ul>\n<li>Right-click and move to Paste Special &gt; Other Paste Special Options and pick \u201cFormatting.\u201d<\/li>\n<li>Click the Paste drop-down arrow in the Clipboard section on the Home tab. Move down to Other Paste Special Options and pick \u201cFormatting.\u201d<\/li>\n<li>Click the Paste drop-down arrow on the Home tab and pick Paste Special. Mark the option for Formats in the dialog box and click \u201cOK.\u201d<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-788668\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/HomePasteSpecial-ExcelCopyConditionalFormatting.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Paste Special Formatting option\" width=\"430\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll then see the formatting apply to your selected cells. Again, you can confirm that the rule copied and not just the formatting by viewing the Conditional Formatting Rules Manager.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-788667\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/ConfirmPasteSpecial-ExcelCopyConditionalFormatting.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Confirm the rule in the Manager\" width=\"650\" height=\"183\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Copy_Formatting_Using_the_Conditional_Formatting_Rules_Manager\"><\/span>Copy Formatting Using the Conditional Formatting Rules Manager<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The Conditional Formatting Rules Manager helps you <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/771483\/how-to-manage-conditional-formatting-rules-in-microsoft-excel\/\">keep track of rules you\u2019ve set up in your sheet or workbook. It can also help you copy formatting by making a duplicate rule and then editing it slightly to fit other cells.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Manage Conditional Formatting Rules in Microsoft Excel<\/em><\/strong><\/p>\n<p>Open the tool by going to the Home tab and clicking the Conditional Formatting drop-down arrow. Select \u201cManage Rules.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-788674\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/HomeManageRules-ExcelCopyConditionalFormatting.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Manage Rules in the Conditional Formatting drop-down list\" width=\"650\" height=\"326\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When the Conditional Formatting Rules Manager opens, select \u201cThis Worksheet\u201d in the drop-down box at the top. If the rule you want to duplicate is on a different sheet, you can select it from the drop-down list instead.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-788673\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/SelectSheet-ExcelCopyConditionalFormatting.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select a sheet\" width=\"650\" height=\"215\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Then, select the rule you want to copy at the bottom and click \u201cDuplicate Rule.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-788672\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/DuplicateRule-ExcelCopyConditionalFormatting.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Duplicate the rule\" width=\"650\" height=\"176\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>An exact copy of the rule will appear. You can then change the cell range in the Applies To box on the right for the new cells or select the sheet and the cells with your cursor to populate the box. You can also make other adjustments to the format if you like.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-788671\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/ChangeDuplicateRule-ExcelCopyConditionalFormatting.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Changed cell range for the duplicated rule\" width=\"650\" height=\"208\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click \u201cApply\u201d to apply the rule to the new cells and \u201cClose\u201d to exit the Rules Manager window.<\/p>\n<p>Conditional formatting gives you a great way to make certain data in your sheet stand out. So if you decide to apply the same rule to other cells or sheets, remember to save some time and just copy it!<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/788658\/how-to-copy-conditional-formatting-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Copy Conditional Formatting in Microsoft Excel&#8221; If you use conditional formatting in Microsoft Excel to automatically format cells that match criteria, you may want to apply the same rule to another part of your sheet or workbook. Instead of creating a new rule, just copy it. You might have a conditional formatting rule&#8230;<\/p>\n","protected":false},"author":1,"featured_media":415452,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-415451","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/415451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=415451"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/415451\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/415452"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=415451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=415451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=415451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}