{"id":5703,"date":"2017-02-23T23:15:07","date_gmt":"2017-02-23T23:15:07","guid":{"rendered":"https:\/\/wordherd.io\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\/"},"modified":"2017-02-23T23:15:07","modified_gmt":"2017-02-23T23:15:07","slug":"how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba","status":"publish","type":"post","link":"https:\/\/wordherd.io\/de\/blog\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\/","title":{"rendered":"How To Find And Remove Bold Formatting In An Excel Spreadsheet With VBA"},"content":{"rendered":"

In case your spreadsheet accommodates undesirable formatting, VBA can selectively take away the codecs and add new standards. A typical state of affairs may be a conditional format based mostly on particular values however now you could apply new situations.<\/p>\n

This text explains how one can determine cells with daring sort, take away the formatting.and add new standards.<\/p>\n

Figuring out Daring Kind In Every Cell With VBA<\/strong><\/p>\n

The instance we’ll use is a numeric knowledge record that has daring sort the place the worth is over 1000. Now you could enhance the conditional worth to 1500, however change the format to daring, and purple.<\/p>\n

The info may look one thing like this:
\n<\/p>\n

\n
Information\n
400\n
488\n
234\n
2355\n
234\n
1600\n
<\/pre>\n
The process we’ll write will take away the daring format from every cell earlier than making use of the brand new formatting standards.
\n<\/p>\n
\n
dim rng as vary\n
set rng=vary(\"a1\").currentRegion.columns(1)\n
dim n as lengthy\n
n=1500\n
for x=2 to rng.rows.depend<\/p>
if rng.rows(x).font.daring then<\/p>
rng.rows(x).font.daring=false\n
finish if<\/p>
<\/pre>\n
With the daring sort eliminated, the code can now apply the brand new format standards.<\/p>\n
\n
myValue=rng.rows(x)\n
If myValue > 1500 Then<\/p>
rng.Rows(x).Font.Daring = True<\/p>
rng.Rows(x).Font.ColorIndex = three\n
Finish If\n
subsequent\n
<\/pre>\n<\/p>\n
The code now produces an output which shows all values higher than 1500 in daring and purple sort.<\/p>\n
Such a process can simply be developed so as to add different formatting sorts. For instance, to extend the font measurement, the scale property could be accessed.
\n<\/p>\n
 \n
rng.Rows(x).Font.Measurement = 16\n
<\/pre>\n<\/p>\n
It may be helpful to know the totally different properties out there when working with cell codecs. A method to do that is by recording a macro. Begin recording, after which choose a cell worth and alter a number of of the settings similar to shade and measurement. Should you view the ensuing macro you may see one thing like this.
\n<\/p>\n
<\/p>
With Choice.Font\n
.Title = \"Arial\"\n
.Measurement = 10\n
.Strikethrough = False\n
.Superscript = False\n
.Subscript = False\n
.OutlineFont = False\n
.Shadow = False\n
.Underline = xlUnderlineStyleNone\n
.ColorIndex = three\n
.Font.Daring = True<\/p>
Finish With\n
<\/pre>\n<\/p>\n
The macro shows quite a lot of formatting properties you may then use in your personal code and could be added to your code library.<\/p>\n
Abstract<\/strong><\/p>\n
Though Excel has some robust formatting instruments, VBA allows builders to customise an answer to go well with their very own wants. By including this sort of process to a code library it may possibly enhance productiveness and effectivity to any new challenge.<\/p>\n
Quelle<\/a> von Andy L Gibson<\/a><\/div>","protected":false},"excerpt":{"rendered":"
In case your spreadsheet accommodates undesirable formatting, VBA can selectively take away the codecs and add new standards. A typical state of affairs may be a conditional format based mostly on particular values however now you could apply new situations. This text explains how one can determine cells with daring sort, take away the formatting.and […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"footnotes":""},"categories":[15],"tags":[200,595],"builders":[],"industry":[],"platform":[],"class_list":["post-5703","post","type-post","status-publish","format-standard","hentry","category-wordpress","tag-wordpress","tag-wordpress-tutorial"],"acf":[],"yoast_head":"\nHow To Find And Remove Bold Formatting In An Excel Spreadsheet With VBA - WordHerd WordPress Migration<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wordherd.io\/de\/blog\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Find And Remove Bold Formatting In An Excel Spreadsheet With VBA - WordHerd WordPress Migration\" \/>\n<meta property=\"og:description\" content=\"In case your spreadsheet accommodates undesirable formatting, VBA can selectively take away the codecs and add new standards. A typical state of affairs may be a conditional format based mostly on particular values however now you could apply new situations. This text explains how one can determine cells with daring sort, take away the formatting.and […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wordherd.io\/de\/blog\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"WordHerd WordPress Migration\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/wordherdio\/\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-23T23:15:07+00:00\" \/>\n<meta name=\"author\" content=\"WordHerd\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@wordherdio\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"WordHerd\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\\\/\"},\"author\":{\"name\":\"WordHerd\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/#\\\/schema\\\/person\\\/373419b97c0fbc45a3a16462bdba0fac\"},\"headline\":\"How To Find And Remove Bold Formatting In An Excel Spreadsheet With VBA\",\"datePublished\":\"2017-02-23T23:15:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\\\/\"},\"wordCount\":343,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/#organization\"},\"keywords\":[\"WordPress\",\"wordpress tutorial\"],\"articleSection\":[\"WordPress\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/wordherd.io\\\/blog\\\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\\\/\",\"url\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\\\/\",\"name\":\"How To Find And Remove Bold Formatting In An Excel Spreadsheet With VBA - WordHerd WordPress Migration\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/#website\"},\"datePublished\":\"2017-02-23T23:15:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/wordherd.io\\\/blog\\\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/wordherd.io\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Find And Remove Bold Formatting In An Excel Spreadsheet With VBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/#website\",\"url\":\"https:\\\/\\\/wordherd.io\\\/\",\"name\":\"WordHerd WordPress Migration\",\"description\":\"Website Migration Services\",\"publisher\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/wordherd.io\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/#organization\",\"name\":\"WordHerd WordPress Migration\",\"url\":\"https:\\\/\\\/wordherd.io\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/wordherd.io\\\/wp-content\\\/uploads\\\/wordherd-trademark.png\",\"contentUrl\":\"https:\\\/\\\/wordherd.io\\\/wp-content\\\/uploads\\\/wordherd-trademark.png\",\"width\":1000,\"height\":315,\"caption\":\"WordHerd WordPress Migration\"},\"image\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/#\\\/schema\\\/person\\\/373419b97c0fbc45a3a16462bdba0fac\",\"name\":\"WordHerd\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bf8c7166601a64c6c57b67ffbeab8f8c6a378cca786da9a326c1a34a2ec6f860?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bf8c7166601a64c6c57b67ffbeab8f8c6a378cca786da9a326c1a34a2ec6f860?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bf8c7166601a64c6c57b67ffbeab8f8c6a378cca786da9a326c1a34a2ec6f860?s=96&d=mm&r=g\",\"caption\":\"WordHerd\"},\"sameAs\":[\"https:\\\/\\\/wordherd.io\",\"https:\\\/\\\/www.facebook.com\\\/wordherdio\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/wordherd\",\"https:\\\/\\\/x.com\\\/wordherdio\"],\"url\":\"https:\\\/\\\/wordherd.io\\\/de\\\/blog\\\/author\\\/wordherd\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Find And Remove Bold Formatting In An Excel Spreadsheet With VBA - WordHerd WordPress Migration","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:\/\/wordherd.io\/de\/blog\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\/","og_locale":"de_DE","og_type":"article","og_title":"How To Find And Remove Bold Formatting In An Excel Spreadsheet With VBA - WordHerd WordPress Migration","og_description":"In case your spreadsheet accommodates undesirable formatting, VBA can selectively take away the codecs and add new standards. A typical state of affairs may be a conditional format based mostly on particular values however now you could apply new situations. This text explains how one can determine cells with daring sort, take away the formatting.and […]","og_url":"https:\/\/wordherd.io\/de\/blog\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\/","og_site_name":"WordHerd WordPress Migration","article_author":"https:\/\/www.facebook.com\/wordherdio\/","article_published_time":"2017-02-23T23:15:07+00:00","author":"WordHerd","twitter_card":"summary_large_image","twitter_creator":"@wordherdio","twitter_misc":{"Verfasst von":"WordHerd","Gesch\u00e4tzte Lesezeit":"2\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/wordherd.io\/blog\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\/#article","isPartOf":{"@id":"https:\/\/wordherd.io\/blog\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\/"},"author":{"name":"WordHerd","@id":"https:\/\/wordherd.io\/#\/schema\/person\/373419b97c0fbc45a3a16462bdba0fac"},"headline":"How To Find And Remove Bold Formatting In An Excel Spreadsheet With VBA","datePublished":"2017-02-23T23:15:07+00:00","mainEntityOfPage":{"@id":"https:\/\/wordherd.io\/blog\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\/"},"wordCount":343,"commentCount":0,"publisher":{"@id":"https:\/\/wordherd.io\/#organization"},"keywords":["WordPress","wordpress tutorial"],"articleSection":["WordPress"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/wordherd.io\/blog\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/wordherd.io\/blog\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\/","url":"https:\/\/wordherd.io\/blog\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\/","name":"How To Find And Remove Bold Formatting In An Excel Spreadsheet With VBA - WordHerd WordPress Migration","isPartOf":{"@id":"https:\/\/wordherd.io\/#website"},"datePublished":"2017-02-23T23:15:07+00:00","breadcrumb":{"@id":"https:\/\/wordherd.io\/blog\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wordherd.io\/blog\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/wordherd.io\/blog\/how-to-find-and-remove-bold-formatting-in-an-excel-spreadsheet-with-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wordherd.io\/"},{"@type":"ListItem","position":2,"name":"How To Find And Remove Bold Formatting In An Excel Spreadsheet With VBA"}]},{"@type":"WebSite","@id":"https:\/\/wordherd.io\/#website","url":"https:\/\/wordherd.io\/","name":"WordHerd WordPress Migration","description":"Websitesitzungsdienstleistungen","publisher":{"@id":"https:\/\/wordherd.io\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wordherd.io\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/wordherd.io\/#organization","name":"WordHerd WordPress Migration","url":"https:\/\/wordherd.io\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/wordherd.io\/#\/schema\/logo\/image\/","url":"https:\/\/wordherd.io\/wp-content\/uploads\/wordherd-trademark.png","contentUrl":"https:\/\/wordherd.io\/wp-content\/uploads\/wordherd-trademark.png","width":1000,"height":315,"caption":"WordHerd WordPress Migration"},"image":{"@id":"https:\/\/wordherd.io\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/wordherd.io\/#\/schema\/person\/373419b97c0fbc45a3a16462bdba0fac","name":"WordHerd","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/secure.gravatar.com\/avatar\/bf8c7166601a64c6c57b67ffbeab8f8c6a378cca786da9a326c1a34a2ec6f860?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/bf8c7166601a64c6c57b67ffbeab8f8c6a378cca786da9a326c1a34a2ec6f860?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bf8c7166601a64c6c57b67ffbeab8f8c6a378cca786da9a326c1a34a2ec6f860?s=96&d=mm&r=g","caption":"WordHerd"},"sameAs":["https:\/\/wordherd.io","https:\/\/www.facebook.com\/wordherdio\/","https:\/\/www.linkedin.com\/company\/wordherd","https:\/\/x.com\/wordherdio"],"url":"https:\/\/wordherd.io\/de\/blog\/author\/wordherd\/"}]}},"_links":{"self":[{"href":"https:\/\/wordherd.io\/de\/wp-json\/wp\/v2\/posts\/5703","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordherd.io\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordherd.io\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordherd.io\/de\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/wordherd.io\/de\/wp-json\/wp\/v2\/comments?post=5703"}],"version-history":[{"count":0,"href":"https:\/\/wordherd.io\/de\/wp-json\/wp\/v2\/posts\/5703\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordherd.io\/de\/wp-json\/wp\/v2\/media?parent=5703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordherd.io\/de\/wp-json\/wp\/v2\/categories?post=5703"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordherd.io\/de\/wp-json\/wp\/v2\/tags?post=5703"},{"taxonomy":"builders","embeddable":true,"href":"https:\/\/wordherd.io\/de\/wp-json\/wp\/v2\/builders?post=5703"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/wordherd.io\/de\/wp-json\/wp\/v2\/industry?post=5703"},{"taxonomy":"platform","embeddable":true,"href":"https:\/\/wordherd.io\/de\/wp-json\/wp\/v2\/platform?post=5703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}