{"id":3757,"date":"2023-07-15T17:45:06","date_gmt":"2023-07-15T17:45:06","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/"},"modified":"2023-07-15T17:45:06","modified_gmt":"2023-07-15T17:45:06","slug":"google-sheet-pemformatan-bersyarat-jika-sel-lain-berisi-teks","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/","title":{"rendered":"Google spreadsheet: pemformatan bersyarat jika sel lain berisi teks"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fitur <strong>rumus khusus<\/strong> di Google Spreadsheet untuk menerapkan pemformatan bersyarat ke sel berdasarkan apakah sel lain berisi teks tertentu atau tidak.<\/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 jika sel lain berisi teks di Google Spreadsheet<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30598 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/condition1-1.jpg\" alt=\"\" width=\"486\" height=\"458\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menyorot setiap sel di kolom <strong>Tim<\/strong> berdasarkan teks di sel terkait di kolom <strong>Peringkat<\/strong> .<\/span><\/p>\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-30599 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/condition2.jpg\" alt=\"\" width=\"548\" height=\"477\" 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\">=C2=\"Great\"\n<\/span><\/strong><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30600 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/condition3.jpg\" alt=\"\" width=\"307\" height=\"601\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>Selesai<\/strong> , setiap sel di kolom <strong>Tim<\/strong> yang memiliki nilai &#8220;Sangat Baik&#8221; di kolom <strong>Peringkat<\/strong> akan disorot dengan latar belakang hijau:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30601 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/etat4.jpg\" alt=\"\" width=\"491\" height=\"500\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Anda juga dapat menerapkan pemformatan bersyarat ke sel yang berisi nilai teks lain dengan mengklik <strong>Tambahkan aturan lain<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30602 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/condition5.jpg\" alt=\"\" width=\"378\" height=\"435\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Anda kemudian dapat mengulangi proses untuk menentukan warna latar belakang nama tim yang memiliki tulisan &#8220;Baik&#8221; atau &#8220;Buruk&#8221; di kolom <strong>Peringkat<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30603 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/etat6.jpg\" alt=\"\" width=\"382\" height=\"488\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Setiap sel di kolom <strong>Tim<\/strong> akan menerima pemformatan bersyarat berdasarkan nilai yang sesuai di kolom <strong>Peringkat<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30604 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/etat7.jpg\" alt=\"\" width=\"485\" height=\"474\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Setiap <strong>tim<\/strong> dengan <strong>rating<\/strong> \u201cSangat Baik\u201d memiliki latar belakang hijau.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Setiap <strong>tim<\/strong> dengan <strong>penilaian<\/strong> \u201cBaik\u201d memiliki latar belakang kuning.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Setiap <strong>tim<\/strong> dengan <strong>rating<\/strong> &#8220;Buruk&#8221; memiliki latar belakang merah.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Jika sebuah <strong>tim<\/strong> memiliki nilai <strong>rating<\/strong> selain ketiga nilai tersebut, mereka hanya akan mempertahankan warna latar belakang putih.<\/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> <a href=\"https:\/\/statorials.org\/id\/google-sheet-jika-tanggalnya-sebelum-hari-ini\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: pemformatan bersyarat jika tanggal sebelum hari ini<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-kondisi\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: pemformatan bersyarat dengan berbagai kondisi<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fitur rumus khusus di Google Spreadsheet untuk menerapkan pemformatan bersyarat ke sel berdasarkan apakah sel lain berisi teks tertentu atau tidak. Contoh berikut memperlihatkan cara menggunakan fungsi rumus kustom dalam praktiknya. Contoh: Pemformatan bersyarat jika sel lain berisi teks di Google Spreadsheet Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet yang [&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 jika sel lain berisi teks \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Google Spreadsheet jika sel lain berisi teks tertentu.\" \/>\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-pemformatan-bersyarat-jika-sel-lain-berisi-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 jika sel lain berisi teks \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Google Spreadsheet jika sel lain berisi teks tertentu.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T17:45:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/condition1-1.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=\"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-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/\",\"name\":\"Google Spreadsheet: pemformatan bersyarat jika sel lain berisi teks \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T17:45:06+00:00\",\"dateModified\":\"2023-07-15T17:45:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Google Spreadsheet jika sel lain berisi teks tertentu.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: pemformatan bersyarat jika sel lain berisi 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 jika sel lain berisi teks \u2013 Statorial","description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Google Spreadsheet jika sel lain berisi teks tertentu.","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-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: pemformatan bersyarat jika sel lain berisi teks \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Google Spreadsheet jika sel lain berisi teks tertentu.","og_url":"https:\/\/statorials.org\/id\/google-sheet-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/","og_site_name":"Statorials","article_published_time":"2023-07-15T17:45:06+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/condition1-1.jpg"}],"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-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/","url":"https:\/\/statorials.org\/id\/google-sheet-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/","name":"Google Spreadsheet: pemformatan bersyarat jika sel lain berisi teks \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T17:45:06+00:00","dateModified":"2023-07-15T17:45:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Google Spreadsheet jika sel lain berisi teks tertentu.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: pemformatan bersyarat jika sel lain berisi 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\/3757"}],"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=3757"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3757\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3757"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3757"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3757"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}