{"id":4373,"date":"2023-07-11T15:00:36","date_gmt":"2023-07-11T15:00:36","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-memformat-nilai-duplikat-bersyarat\/"},"modified":"2023-07-11T15:00:36","modified_gmt":"2023-07-11T15:00:36","slug":"vba-memformat-nilai-duplikat-bersyarat","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-memformat-nilai-duplikat-bersyarat\/","title":{"rendered":"Vba: menerapkan pemformatan bersyarat ke nilai duplikat"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut di VBA untuk menerapkan pemformatan bersyarat untuk menduplikasi nilai dalam rentang tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> ConditionalFormatDuplicates()\n\n<span style=\"color: #0000ff;\">Dim<\/span> rg <span style=\"color: #0000ff;\">As<\/span> Range\n<span style=\"color: #0000ff;\">Dim<\/span> uv <span style=\"color: #0000ff;\">As<\/span> UniqueValues\n\n<span style=\"color: #008000;\">'specify range to apply conditional formatting\n<\/span><span style=\"color: #0000ff;\">Set<\/span> rg = Range(\" <span style=\"color: #ff0000;\">A2:A11<\/span> \")\n\n<span style=\"color: #008000;\">'clear any existing conditional formatting\n<\/span>rg.FormatConditions.Delete\n\n<span style=\"color: #008000;\">'identify duplicate values in range A2:A11\n<\/span><span style=\"color: #0000ff;\">Set<\/span> uv = rg.FormatConditions.AddUniqueValues\nuv.DupeUnique = xlDuplicate\n\n<span style=\"color: #008000;\">'apply conditional formatting to duplicate values\n<\/span>uv.Interior.Color = vbBlue\nuv.Font.Color = vbWhite\nuv.Font.Bold = True\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini menerapkan pemformatan bersyarat untuk menduplikasi nilai dalam rentang <strong>A2:A11<\/strong> pada lembar saat ini di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Gunakan VBA untuk Menerapkan Pemformatan Bersyarat ke Nilai Duplikat<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kolom nilai berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34329 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbadupes1.jpg\" alt=\"\" width=\"466\" height=\"424\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menerapkan pemformatan bersyarat berikut ke nilai duplikat di kolom A:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Latar belakang biru<\/span><\/li>\n<li> <span style=\"color: #000000;\">Teks hitam<\/span><\/li>\n<li> <span style=\"color: #000000;\">Teks tebal<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> ConditionalFormatDuplicates()\n\n<span style=\"color: #0000ff;\">Dim<\/span> rg <span style=\"color: #0000ff;\">As<\/span> Range\n<span style=\"color: #0000ff;\">Dim<\/span> uv <span style=\"color: #0000ff;\">As<\/span> UniqueValues\n\n<span style=\"color: #008000;\">'specify range to apply conditional formatting\n<\/span><span style=\"color: #0000ff;\">Set<\/span> rg = Range(\" <span style=\"color: #ff0000;\">A2:A11<\/span> \")\n\n<span style=\"color: #008000;\">'clear any existing conditional formatting\n<\/span>rg.FormatConditions.Delete\n\n<span style=\"color: #008000;\">'identify duplicate values in range A2:A11\n<\/span><span style=\"color: #0000ff;\">Set<\/span> uv = rg.FormatConditions.AddUniqueValues\nuv.DupeUnique = xlDuplicate\n\n<span style=\"color: #008000;\">'apply conditional formatting to duplicate values\n<\/span>uv.Interior.Color = vbBlue\nuv.Font.Color = vbWhite\nuv.Font.Bold = True\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34328 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbadupes2.jpg\" alt=\"\" width=\"483\" height=\"424\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa pemformatan bersyarat diterapkan ke setiap sel di kolom A dengan nilai duplikat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin menerapkan pemformatan bersyarat ke rentang sel yang berbeda, cukup ganti <strong>A2:A11<\/strong> di makro dengan rentang yang berbeda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Selain itu, jika Anda ingin menghapus semua pemformatan bersyarat dari sel pada lembar saat ini, Anda bisa membuat makro berikut untuk melakukannya:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> RemoveConditionalFormatting()\nActiveSheet.Cells.FormatConditions.Delete\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34329 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbadupes1.jpg\" alt=\"\" width=\"466\" height=\"424\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa semua pemformatan bersyarat telah dihapus dari sel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/jumlah-vba-unik\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung nilai unik dalam rentang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menghitung-sel-dengan-teks-tertentu\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung sel dengan teks tertentu<\/a><br \/> VBA: Cara menulis fungsi COUNTIF dan COUNTIFS<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut di VBA untuk menerapkan pemformatan bersyarat untuk menduplikasi nilai dalam rentang tertentu: Sub ConditionalFormatDuplicates() Dim rg As Range Dim uv As UniqueValues &#8216;specify range to apply conditional formatting Set rg = Range(&#8221; A2:A11 &#8220;) &#8216;clear any existing conditional formatting rg.FormatConditions.Delete &#8216;identify duplicate values in range A2:A11 Set uv = [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA: menerapkan pemformatan bersyarat untuk menduplikasi nilai \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat untuk menduplikasi nilai dalam rentang tertentu di Excel, dengan sebuah contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/vba-memformat-nilai-duplikat-bersyarat\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: menerapkan pemformatan bersyarat untuk menduplikasi nilai \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat untuk menduplikasi nilai dalam rentang tertentu di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-memformat-nilai-duplikat-bersyarat\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T15:00:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbadupes1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/vba-memformat-nilai-duplikat-bersyarat\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-memformat-nilai-duplikat-bersyarat\/\",\"name\":\"VBA: menerapkan pemformatan bersyarat untuk menduplikasi nilai \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T15:00:36+00:00\",\"dateModified\":\"2023-07-11T15:00:36+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat untuk menduplikasi nilai dalam rentang tertentu di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-memformat-nilai-duplikat-bersyarat\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-memformat-nilai-duplikat-bersyarat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-memformat-nilai-duplikat-bersyarat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: menerapkan pemformatan bersyarat ke nilai duplikat\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA: menerapkan pemformatan bersyarat untuk menduplikasi nilai \u2013 Statologi","description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat untuk menduplikasi nilai dalam rentang tertentu di Excel, dengan sebuah contoh.","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:\/\/statorials.org\/id\/vba-memformat-nilai-duplikat-bersyarat\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: menerapkan pemformatan bersyarat untuk menduplikasi nilai \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat untuk menduplikasi nilai dalam rentang tertentu di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vba-memformat-nilai-duplikat-bersyarat\/","og_site_name":"Statorials","article_published_time":"2023-07-11T15:00:36+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbadupes1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/vba-memformat-nilai-duplikat-bersyarat\/","url":"https:\/\/statorials.org\/id\/vba-memformat-nilai-duplikat-bersyarat\/","name":"VBA: menerapkan pemformatan bersyarat untuk menduplikasi nilai \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T15:00:36+00:00","dateModified":"2023-07-11T15:00:36+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat untuk menduplikasi nilai dalam rentang tertentu di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-memformat-nilai-duplikat-bersyarat\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-memformat-nilai-duplikat-bersyarat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-memformat-nilai-duplikat-bersyarat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: menerapkan pemformatan bersyarat ke nilai duplikat"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4373"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4373"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4373\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}