{"id":6974,"date":"2017-10-19T16:09:03","date_gmt":"2017-10-19T14:09:03","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=6974"},"modified":"2024-05-17T20:37:34","modified_gmt":"2024-05-17T18:37:34","slug":"replace-excel-formatting-with-another-formatting","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/replace-excel-formatting-with-another-formatting\/","title":{"rendered":"Replace Excel Formatting with Another Formatting"},"content":{"rendered":"<p>Imagine this, you have a table full of bold text.\u00a0 The bold text could also be all over your worksheet in random cells.<\/p>\n<p>Then you decide that the <strong>bold<\/strong> text does not suit your expected design and prefer <strong><span style=\"color: #ff0000\">red<\/span> <\/strong>colored text instead.<\/p>\n<p>What would you do?<\/p>\n<p>Changing all of the formatting one by one would be a big pain!!!<\/p>\n<p>Thankfully, Excel allows you to <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/replace-one-character\/\" target=\"_blank\" rel=\"noopener\">replace formatting with another<\/a> formatting<\/strong>!<\/p>\n<p>This is our initial Table:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-00.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Replace Excel Formatting with Another Formatting\" class=\"alignnone size-full wp-image-6975\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-00.jpg\" alt=\"Replace Excel Formatting with Another Formatting\" width=\"301\" height=\"178\" \/><\/a><\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/XZ58jjhpdPM?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Replace-Formatting-with-Another-Formatting.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong> <\/span>Go to\u00a0<em><strong>Home &gt; Find \u00a0&amp; Select<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Replace Excel Formatting with Another Formatting\" class=\"alignnone size-full wp-image-6976\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-01.jpg\" alt=\"Replace Excel Formatting with Another Formatting\" width=\"1137\" height=\"127\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-01.jpg 1137w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-01-300x34.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-01-1024x114.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-01-768x86.jpg 768w\" sizes=\"(max-width: 1137px) 100vw, 1137px\" \/><\/a><\/p>\n<p>Then select the\u00a0<strong>Replace\u00a0<\/strong>option.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Replace Excel Formatting with Another Formatting\" class=\"alignnone size-full wp-image-6977\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-02.jpg\" alt=\"Replace Excel Formatting with Another Formatting\" width=\"204\" height=\"355\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-02.jpg 204w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-02-172x300.jpg 172w\" sizes=\"(max-width: 204px) 100vw, 204px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> Select\u00a0<strong>Options<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Replace Excel Formatting with Another Formatting\" class=\"alignnone size-full wp-image-6978\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-03.jpg\" alt=\"Replace Excel Formatting with Another Formatting\" width=\"452\" height=\"194\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-03.jpg 452w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-03-300x129.jpg 300w\" sizes=\"(max-width: 452px) 100vw, 452px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong> <\/span>Select\u00a0<strong>Format<\/strong>.\u00a0 We will set the format that we want to change.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Replace Excel Formatting with Another Formatting\" class=\"alignnone size-full wp-image-6979\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-04.jpg\" alt=\"Replace Excel Formatting with Another Formatting\" width=\"452\" height=\"243\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-04.jpg 452w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-04-300x161.jpg 300w\" sizes=\"(max-width: 452px) 100vw, 452px\" \/><\/a><\/p>\n<p>Make sure\u00a0<strong>Bold<\/strong> is selected. Click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-05.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Replace Excel Formatting with Another Formatting\" class=\"alignnone size-full wp-image-6980\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-05.jpg\" alt=\"Replace Excel Formatting with Another Formatting\" width=\"529\" height=\"499\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-05.jpg 529w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-05-300x283.jpg 300w\" sizes=\"(max-width: 529px) 100vw, 529px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong> <\/span>Select the second\u00a0<strong>Format<\/strong>.\u00a0 We will set the format that we want to be the final formatting.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-05b.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Replace Excel Formatting with Another Formatting\" class=\"alignnone size-full wp-image-6985\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-05b.jpg\" alt=\"Replace Excel Formatting with Another Formatting\" width=\"452\" height=\"243\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-05b.jpg 452w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-05b-300x161.jpg 300w\" sizes=\"(max-width: 452px) 100vw, 452px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Make sure the color\u00a0<strong><span style=\"color: #ff0000\">Red<\/span>\u00a0<\/strong>is selected. Click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-06.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Replace Excel Formatting with Another Formatting\" class=\"alignnone size-full wp-image-6981\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-06.jpg\" alt=\"Replace Excel Formatting with Another Formatting\" width=\"529\" height=\"499\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-06.jpg 529w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-06-300x283.jpg 300w\" sizes=\"(max-width: 529px) 100vw, 529px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5:<\/strong>\u00a0<span style=\"color: #000000\">Click\u00a0<strong>Replace All\u00a0<\/strong>and see the magic happen!<\/span><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-07.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Replace Excel Formatting with Another Formatting\" class=\"alignnone size-full wp-image-6982\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-07.jpg\" alt=\"Replace Excel Formatting with Another Formatting\" width=\"452\" height=\"243\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-07.jpg 452w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-07-300x161.jpg 300w\" sizes=\"(max-width: 452px) 100vw, 452px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>The formatting is now replaced with the color Red!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-08.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Replace Excel Formatting with Another Formatting\" class=\"alignnone size-full wp-image-6983\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-08.jpg\" alt=\"Replace Excel Formatting with Another Formatting\" width=\"304\" height=\"180\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-08.jpg 304w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Replace-Formatting-with-Another-Formatting-08-300x178.jpg 300w\" sizes=\"(max-width: 304px) 100vw, 304px\" \/><\/a><\/p>\n<p><span style=\"color: #0000ff\"><strong>Replace Excel Formatting with Another Formatting<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;color: #0000ff\"><strong>Helpful Resource:<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-722 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/728x901-e1413496235820.gif\" alt=\"728x90\" width=\"599\" height=\"74\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Imagine this, you have a table full of bold text.\u00a0 The bold text could also be all over your worksheet in random cells. Then you decide that the bold text does not suit your expected design and prefer red colored text instead. What would you do? Changing all of the formatting one by one would [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17759,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Replace Excel Formatting with Another Formatting","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,37],"tags":[88,74,188],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6974"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=6974"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6974\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17759"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=6974"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=6974"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=6974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}