{"id":3758,"date":"2023-07-15T17:33:57","date_gmt":"2023-07-15T17:33:57","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-format-bersyarat-jika-sel-lain-tidak-kosong\/"},"modified":"2023-07-15T17:33:57","modified_gmt":"2023-07-15T17:33:57","slug":"google-sheet-format-bersyarat-jika-sel-lain-tidak-kosong","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-format-bersyarat-jika-sel-lain-tidak-kosong\/","title":{"rendered":"Google spreadsheet: pemformatan bersyarat jika sel lain tidak kosong"},"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 jika sel lain tidak kosong.<\/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-30610 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cond0.jpg\" alt=\"\" width=\"495\" height=\"464\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menyorot setiap sel di kolom <strong>Tim<\/strong> jika sel di kolom <strong>Peringkat<\/strong> terkait tidak kosong.<\/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\">=NOT(ISBLANK( <span dir=\"auto\">C2<\/span> ))\n<\/span><\/strong><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30612 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cond1.jpg\" alt=\"\" width=\"317\" height=\"621\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Penting untuk menyertakan tanda sama dengan ( <strong>=<\/strong> ) di awal rumus, jika tidak, pemformatan bersyarat tidak akan berfungsi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>Selesai<\/strong> , setiap sel di kolom <strong>Tim<\/strong> yang nilai terkaitnya di kolom <strong>Peringkat<\/strong> tidak kosong akan disorot dengan latar belakang hijau:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30613 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cond2.jpg\" alt=\"\" width=\"483\" height=\"496\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa satu-satunya nilai <strong>tim<\/strong> yang memiliki latar belakang hijau adalah nilai yang sesuai di kolom <strong>Peringkat<\/strong> tidak kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Anda juga bisa menerapkan warna latar belakang yang berbeda ke sel di kolom Tim dengan menentukan warna berbeda di panel <strong>Aturan Format Bersyarat<\/strong> .<\/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><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><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi rumus khusus di Google Spreadsheet untuk menerapkan pemformatan bersyarat ke sel jika sel lain tidak kosong. 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 berisi informasi tentang berbagai [&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 tidak kosong - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Google Spreadsheet jika sel lain tidak kosong, beserta 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\/google-sheet-format-bersyarat-jika-sel-lain-tidak-kosong\/\" \/>\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 tidak kosong - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Google Spreadsheet jika sel lain tidak kosong, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-format-bersyarat-jika-sel-lain-tidak-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T17:33:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cond0.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-format-bersyarat-jika-sel-lain-tidak-kosong\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-format-bersyarat-jika-sel-lain-tidak-kosong\/\",\"name\":\"Google Spreadsheet: pemformatan bersyarat jika sel lain tidak kosong - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T17:33:57+00:00\",\"dateModified\":\"2023-07-15T17:33:57+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 tidak kosong, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-format-bersyarat-jika-sel-lain-tidak-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-format-bersyarat-jika-sel-lain-tidak-kosong\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-format-bersyarat-jika-sel-lain-tidak-kosong\/#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 tidak kosong\"}]},{\"@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 tidak kosong - Statorial","description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Google Spreadsheet jika sel lain tidak kosong, beserta 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\/google-sheet-format-bersyarat-jika-sel-lain-tidak-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: pemformatan bersyarat jika sel lain tidak kosong - Statorial","og_description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat ke sel di Google Spreadsheet jika sel lain tidak kosong, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/google-sheet-format-bersyarat-jika-sel-lain-tidak-kosong\/","og_site_name":"Statorials","article_published_time":"2023-07-15T17:33:57+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cond0.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-format-bersyarat-jika-sel-lain-tidak-kosong\/","url":"https:\/\/statorials.org\/id\/google-sheet-format-bersyarat-jika-sel-lain-tidak-kosong\/","name":"Google Spreadsheet: pemformatan bersyarat jika sel lain tidak kosong - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T17:33:57+00:00","dateModified":"2023-07-15T17:33:57+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 tidak kosong, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-format-bersyarat-jika-sel-lain-tidak-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-format-bersyarat-jika-sel-lain-tidak-kosong\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-format-bersyarat-jika-sel-lain-tidak-kosong\/#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 tidak kosong"}]},{"@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\/3758"}],"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=3758"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3758\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3758"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3758"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}