{"id":4895,"date":"2023-07-06T17:40:48","date_gmt":"2023-07-06T17:40:48","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-nilai-teks\/"},"modified":"2023-07-06T17:40:48","modified_gmt":"2023-07-06T17:40:48","slug":"google-sheet-memformat-bersyarat-beberapa-nilai-teks","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-nilai-teks\/","title":{"rendered":"Google spreadsheet: pemformatan bersyarat berdasarkan beberapa nilai teks"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <strong>rumus khusus<\/strong> di Google Spreadsheet untuk menerapkan pemformatan bersyarat ke sel berdasarkan beberapa nilai teks.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan fungsi rumus kustom dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Pemformatan bersyarat berdasarkan beberapa nilai teks di Google Spreadsheet<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet yang menunjukkan posisi dan poin yang dicetak oleh berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38230 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cmu1.png\" alt=\"\" width=\"556\" height=\"386\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin menerapkan pemformatan bersyarat ke setiap sel di kolom <strong>Posisi<\/strong> 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 dapat menyorot sel-sel dalam rentang <strong>A2:A11<\/strong> , lalu klik tab <strong>Format<\/strong> , lalu <strong>Conditional Formatting<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38231 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cmu2.png\" alt=\"\" width=\"518\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di panel <strong>Aturan Format Bersyarat<\/strong> yang muncul di sisi kanan layar, klik menu tarik-turun <strong>Format sel jika<\/strong> , lalu pilih <strong>Rumus khusus adalah<\/strong> , lalu masukkan rumus berikut:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=regexmatch(A2, \"(?i)starting|forward|center\")\n<\/span><\/strong><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-38232\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cmu3.png\" alt=\"Pemformatan bersyarat Google Sheets berdasarkan beberapa nilai teks\" width=\"353\" height=\"620\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>Selesai<\/strong> , setiap sel di kolom <b>Posisi<\/b> yang berisi Mulai, Depan, atau Tengah akan otomatis disorot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38233 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cmu4.png\" alt=\"\" width=\"556\" height=\"404\" srcset=\"\" sizes=\"\"><\/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> <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 Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/google-sheet-pemformatan-bersyarat-antara-dua-nilai\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: pemformatan bersyarat antara dua nilai<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pemformatan-bersyarat-google-sheet-tidak-sama\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Gunakan \u201cTidak Sama\u201d dalam Pemformatan Bersyarat<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: pemformatan bersyarat jika sel lain berisi teks<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi rumus khusus di Google Spreadsheet untuk menerapkan pemformatan bersyarat ke sel berdasarkan beberapa nilai teks. Contoh berikut memperlihatkan cara menggunakan fungsi rumus kustom dalam praktiknya. Contoh: Pemformatan bersyarat berdasarkan beberapa nilai teks di Google Spreadsheet Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet yang menunjukkan posisi dan poin yang dicetak [&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>Google Spreadsheet: pemformatan bersyarat berdasarkan beberapa nilai teks \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Google Spreadsheet berdasarkan beberapa nilai teks, beserta 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\/google-sheet-memformat-bersyarat-beberapa-nilai-teks\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: pemformatan bersyarat berdasarkan beberapa nilai teks \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Google Spreadsheet berdasarkan beberapa nilai teks, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-nilai-teks\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T17:40:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cmu1.png\" \/>\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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-nilai-teks\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-nilai-teks\/\",\"name\":\"Google Spreadsheet: pemformatan bersyarat berdasarkan beberapa nilai teks \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T17:40:48+00:00\",\"dateModified\":\"2023-07-06T17:40:48+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Google Spreadsheet berdasarkan beberapa nilai teks, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-nilai-teks\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-nilai-teks\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-nilai-teks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: 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":"Google Spreadsheet: pemformatan bersyarat berdasarkan beberapa nilai teks \u2013 Statorial","description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Google Spreadsheet berdasarkan beberapa nilai teks, beserta 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\/google-sheet-memformat-bersyarat-beberapa-nilai-teks\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: pemformatan bersyarat berdasarkan beberapa nilai teks \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Google Spreadsheet berdasarkan beberapa nilai teks, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-nilai-teks\/","og_site_name":"Statorials","article_published_time":"2023-07-06T17:40:48+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cmu1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-nilai-teks\/","url":"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-nilai-teks\/","name":"Google Spreadsheet: pemformatan bersyarat berdasarkan beberapa nilai teks \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T17:40:48+00:00","dateModified":"2023-07-06T17:40:48+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Google Spreadsheet berdasarkan beberapa nilai teks, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-nilai-teks\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-nilai-teks\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-nilai-teks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: 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\/4895"}],"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=4895"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4895\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4895"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}