{"id":4121,"date":"2023-07-13T11:10:07","date_gmt":"2023-07-13T11:10:07","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-bersyarat-beberapa-nilai-teks-pemformatan\/"},"modified":"2023-07-13T11:10:07","modified_gmt":"2023-07-13T11:10:07","slug":"excel-bersyarat-beberapa-nilai-teks-pemformatan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-bersyarat-beberapa-nilai-teks-pemformatan\/","title":{"rendered":"Excel: pemformatan bersyarat berdasarkan beberapa nilai teks"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Untuk menerapkan pemformatan bersyarat ke sel Excel yang berisi salah satu dari beberapa teks tertentu, Anda bisa menggunakan opsi <strong>Aturan Baru<\/strong> di menu tarik-turun <strong>Pemformatan Bersyarat<\/strong> pada tab <strong>Beranda<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30972 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/base1.jpg\" alt=\"\" width=\"602\" height=\"513\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan opsi ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Menerapkan pemformatan bersyarat berdasarkan beberapa nilai teks<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan posisi dan poin yang dicetak oleh berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32743 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mt1.png\" alt=\"\" width=\"512\" height=\"489\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin menerapkan pemformatan bersyarat ke setiap sel di kolom Posisi yang berisi teks spesifik berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Keberangkatan<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebelum<\/span><\/li>\n<li> <span style=\"color: #000000;\">Tengah<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita bisa membuat kolom baru yang berisi nilai teks ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami kemudian dapat menyorot nilai-nilai ini di rentang <strong>D2:D4<\/strong> dan memasukkan <strong>teks_spesifik<\/strong> di kotak Nama di sudut kiri atas:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32744 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mt2.png\" alt=\"\" width=\"535\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita dapat menyorot sel-sel dalam rentang <strong>A2:A11<\/strong> , lalu klik menu drop-down <strong>Conditional Formatting<\/strong> pada tab <strong>Home<\/strong> , lalu klik <strong>New Rule<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30972 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/base1.jpg\" alt=\"\" width=\"602\" height=\"513\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik <strong>Gunakan rumus untuk menentukan sel mana yang akan diformat<\/strong> , lalu ketik <strong>=SUM(COUNTIF(A2, \u201c*\u201d&amp; Spesifik_teks&amp;\u201d*\u201d))<\/strong> di dalam kotak, lalu klik tombol <strong>Format<\/strong> dan pilih isian warna. menggunakan.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32746\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mt3.png\" alt=\"Pemformatan bersyarat Excel berdasarkan beberapa nilai teks\" width=\"628\" height=\"403\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah kita menekan <strong>OK<\/strong> , semua sel dalam rentang <strong>A2:A11<\/strong> yang mencakup <em>Mulai<\/em> , <em>Depan<\/em> , atau <em>Tengah<\/em> di suatu tempat di nama posisi akan disorot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32745 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mt4.png\" alt=\"\" width=\"541\" height=\"453\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika kita mengubah nilai teks di kolom D, rumus akan otomatis diperbarui untuk menyorot sel yang berisi nilai teks baru tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita mencari nilai teks <em>Point<\/em> , <em>Shooting<\/em> , dan <em>Power<\/em> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32747 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mt5.png\" alt=\"\" width=\"501\" height=\"427\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sel apa pun dalam rentang <strong>A2:A11<\/strong> yang menyertakan <em>Point<\/em> , <em>Shooting<\/em> , atau <em>Power<\/em> di suatu tempat di nama posisi kini disorot.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Kami memilih untuk menggunakan isian hijau muda untuk pemformatan bersyarat dalam contoh ini, namun Anda dapat memilih warna dan gaya apa pun yang Anda inginkan untuk pemformatan bersyarat.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/tanggal-terlambat-pemformatan-bersyarat-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: Terapkan pemformatan bersyarat pada tanggal jatuh tempo<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/format-kondisional-excel-antara-dua-tanggal\/\" target=\"_blank\" rel=\"noopener\">Excel: terapkan pemformatan bersyarat jika sel berada di antara dua tanggal<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-beberapa-kondisi\/\" target=\"_blank\" rel=\"noopener\">Excel: Menerapkan pemformatan bersyarat berdasarkan beberapa kondisi<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Untuk menerapkan pemformatan bersyarat ke sel Excel yang berisi salah satu dari beberapa teks tertentu, Anda bisa menggunakan opsi Aturan Baru di menu tarik-turun Pemformatan Bersyarat pada tab Beranda . Contoh berikut menunjukkan cara menggunakan opsi ini dalam praktik. Contoh: Menerapkan pemformatan bersyarat berdasarkan beberapa nilai teks Katakanlah kita memiliki kumpulan data berikut di Excel [&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>Excel: pemformatan bersyarat berdasarkan beberapa nilai teks - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Excel berdasarkan beberapa nilai teks, termasuk contohnya.\" \/>\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\/excel-bersyarat-beberapa-nilai-teks-pemformatan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: pemformatan bersyarat berdasarkan beberapa nilai teks - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Excel berdasarkan beberapa nilai teks, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-bersyarat-beberapa-nilai-teks-pemformatan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T11:10:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/base1.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\/excel-bersyarat-beberapa-nilai-teks-pemformatan\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-bersyarat-beberapa-nilai-teks-pemformatan\/\",\"name\":\"Excel: pemformatan bersyarat berdasarkan beberapa nilai teks - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T11:10:07+00:00\",\"dateModified\":\"2023-07-13T11:10:07+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Excel berdasarkan beberapa nilai teks, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-bersyarat-beberapa-nilai-teks-pemformatan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-bersyarat-beberapa-nilai-teks-pemformatan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-bersyarat-beberapa-nilai-teks-pemformatan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: pemformatan bersyarat berdasarkan beberapa nilai teks\"}]},{\"@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":"Excel: pemformatan bersyarat berdasarkan beberapa nilai teks - Statorials","description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Excel berdasarkan beberapa nilai teks, termasuk contohnya.","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\/excel-bersyarat-beberapa-nilai-teks-pemformatan\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: pemformatan bersyarat berdasarkan beberapa nilai teks - Statorials","og_description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Excel berdasarkan beberapa nilai teks, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-bersyarat-beberapa-nilai-teks-pemformatan\/","og_site_name":"Statorials","article_published_time":"2023-07-13T11:10:07+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/base1.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\/excel-bersyarat-beberapa-nilai-teks-pemformatan\/","url":"https:\/\/statorials.org\/id\/excel-bersyarat-beberapa-nilai-teks-pemformatan\/","name":"Excel: pemformatan bersyarat berdasarkan beberapa nilai teks - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T11:10:07+00:00","dateModified":"2023-07-13T11:10:07+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Excel berdasarkan beberapa nilai teks, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-bersyarat-beberapa-nilai-teks-pemformatan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-bersyarat-beberapa-nilai-teks-pemformatan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-bersyarat-beberapa-nilai-teks-pemformatan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: pemformatan bersyarat berdasarkan beberapa nilai teks"}]},{"@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\/4121"}],"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=4121"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4121\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}