{"id":2809,"date":"2023-07-20T14:50:07","date_gmt":"2023-07-20T14:50:07","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-kondisi\/"},"modified":"2023-07-20T14:50:07","modified_gmt":"2023-07-20T14:50:07","slug":"google-sheet-memformat-bersyarat-beberapa-kondisi","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-kondisi\/","title":{"rendered":"Google spreadsheet: pemformatan bersyarat dengan berbagai kondisi"},"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 beberapa kondisi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan fungsi rumus kustom dalam skenario berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1. Pemformatan bersyarat dengan logika OR<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>2. Pemformatan Bersyarat dengan Logika AND<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Ayo pergi!<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Pemformatan bersyarat dengan logika OR<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24667 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionmultiple1.jpg\" alt=\"\" width=\"450\" height=\"406\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menyorot setiap sel di kolom <strong>Tim<\/strong> yang diberi nama &#8220;Spurs&#8221; atau &#8220;Rockets&#8221;.<\/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-24668 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionmultiple2.jpg\" alt=\"\" width=\"538\" height=\"498\" 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\">=( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" string \" dir=\"auto\">\u201c <span style=\"color: #008000;\">Spurs<\/span> \u201d<\/span> ) <span class=\" default-formula-text-color\" dir=\"auto\">+<\/span> ( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" string \" dir=\"auto\">\u201c <span style=\"color: #008000;\">Rockets<\/span> \u201d<\/span> )\n<\/span><\/strong><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24669 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionmultiple3.jpg\" alt=\"\" width=\"293\" height=\"502\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>Selesai<\/strong> , setiap sel di kolom <strong>Tim<\/strong> yang sama dengan &#8220;Spurs&#8221; atau &#8220;Rockets&#8221; akan otomatis disorot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24670 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionmultiple4.jpg\" alt=\"\" width=\"436\" height=\"386\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2:<\/strong><\/span> <span style=\"color: #000000;\"><strong>Pemformatan bersyarat dengan logika AND<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menyorot setiap sel di kolom <strong>Tim<\/strong> yang namanya &#8220;Spurs&#8221; dan nilai terkait di kolom <strong>Poin<\/strong> lebih besar dari 15.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di panel <strong>Aturan Format Bersyarat<\/strong> , klik daftar drop-down <strong>Format sel jika<\/strong> , 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\">=AND( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" string \" dir=\"auto\">\u201c <span style=\"color: #008000;\">Spurs<\/span> \u201d<\/span> , <span dir=\"auto\" style=\"color: #800080;\">B2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">&gt;<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">15<\/span> )\n<\/span><\/strong><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24672 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionmultiple6.jpg\" alt=\"\" width=\"300\" height=\"517\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>Selesai<\/strong> , setiap sel di kolom <strong>Tim<\/strong> yang sama dengan &#8220;Spurs&#8221; dan yang nilainya terkait di kolom <strong>Poin<\/strong> lebih besar dari 15 akan otomatis disorot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24671 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionmultiple5.jpg\" alt=\"\" width=\"445\" height=\"413\" srcset=\"\" sizes=\"\"><\/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-menggantikan-teks\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti teks di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-mengganti-sel-kosong-dengan-nol\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti sel kosong dengan nol di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/lembar-google-vlookup-peka-huruf-besar-kecil\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan VLOOKUP peka huruf besar-kecil di Google Spreadsheet<\/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 fitur rumus khusus di Google Spreadsheet untuk menerapkan pemformatan bersyarat ke sel berdasarkan beberapa kondisi. Contoh berikut memperlihatkan cara menggunakan fungsi rumus kustom dalam skenario berikut: 1. Pemformatan bersyarat dengan logika OR 2. Pemformatan Bersyarat dengan Logika AND Ayo pergi! Contoh 1: Pemformatan bersyarat dengan logika OR Katakanlah kita memiliki kumpulan data [&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 dengan berbagai kondisi - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan pemformatan bersyarat berdasarkan beberapa kondisi di Google Spreadsheet, 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\/google-sheet-memformat-bersyarat-beberapa-kondisi\/\" \/>\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 dengan berbagai kondisi - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan pemformatan bersyarat berdasarkan beberapa kondisi di Google Spreadsheet, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-kondisi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T14:50:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionmultiple1.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-memformat-bersyarat-beberapa-kondisi\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-kondisi\/\",\"name\":\"Google Spreadsheet: pemformatan bersyarat dengan berbagai kondisi - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T14:50:07+00:00\",\"dateModified\":\"2023-07-20T14:50:07+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan pemformatan bersyarat berdasarkan beberapa kondisi di Google Spreadsheet, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-kondisi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-kondisi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-kondisi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: pemformatan bersyarat dengan berbagai kondisi\"}]},{\"@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 dengan berbagai kondisi - Statorial","description":"Tutorial ini menjelaskan cara menggunakan pemformatan bersyarat berdasarkan beberapa kondisi di Google Spreadsheet, 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\/google-sheet-memformat-bersyarat-beberapa-kondisi\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: pemformatan bersyarat dengan berbagai kondisi - Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan pemformatan bersyarat berdasarkan beberapa kondisi di Google Spreadsheet, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-kondisi\/","og_site_name":"Statorials","article_published_time":"2023-07-20T14:50:07+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionmultiple1.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-memformat-bersyarat-beberapa-kondisi\/","url":"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-kondisi\/","name":"Google Spreadsheet: pemformatan bersyarat dengan berbagai kondisi - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T14:50:07+00:00","dateModified":"2023-07-20T14:50:07+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan pemformatan bersyarat berdasarkan beberapa kondisi di Google Spreadsheet, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-kondisi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-kondisi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-kondisi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: pemformatan bersyarat dengan berbagai kondisi"}]},{"@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\/2809"}],"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=2809"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2809\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2809"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2809"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}