{"id":3807,"date":"2023-07-15T10:38:25","date_gmt":"2023-07-15T10:38:25","guid":{"rendered":"https:\/\/statorials.org\/id\/pemformatan-bersyarat-google-sheet-tidak-sama\/"},"modified":"2023-07-15T10:38:25","modified_gmt":"2023-07-15T10:38:25","slug":"pemformatan-bersyarat-google-sheet-tidak-sama","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pemformatan-bersyarat-google-sheet-tidak-sama\/","title":{"rendered":"Google spreadsheet: gunakan \u201ctidak sama\u201d; dalam format bersyarat"},"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 pada sel yang tidak cocok dengan nilai tertentu.<\/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: Cara menggunakan \u201cTidak Sama\u201d dalam pemformatan bersyarat<\/strong><\/span><\/h2>\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-30865 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/eq1.jpg\" alt=\"\" width=\"483\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menyorot setiap sel di kolom <strong>Tim<\/strong> yang nilai terkaitnya di kolom <strong>Poin Untuk<\/strong> dan <strong>Poin Melawan<\/strong> tidak sama.<\/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-30866 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/eq2.jpg\" alt=\"\" width=\"543\" height=\"524\" 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>=B2&lt;&gt;C2<\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30867\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/eq3.jpg\" alt=\"Google Sheets tidak sama dalam hal pemformatan bersyarat\" width=\"326\" height=\"648\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Simbol <strong>&lt;&gt;<\/strong> melambangkan &#8220;tidak sama&#8221; di Google Spreadsheet.<\/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>Poin Untuk<\/strong> dan <strong>Poin Melawan<\/strong> tidak sama akan disorot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30868 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/eq4.jpg\" alt=\"\" width=\"470\" height=\"466\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Secara default, Google Spreadsheet menggunakan latar belakang hijau muda sebagai gaya pemformatan bersyaratnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, Anda mengubah pemformatan bersyarat agar muncul sesuai keinginan Anda dengan mengubah pengaturan default di kotak <strong>Gaya<\/strong> Pemformatan.<\/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-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: pemformatan bersyarat jika sel lain berisi teks<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-format-bersyarat-jika-sel-lain-tidak-kosong\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: pemformatan bersyarat jika sel lain tidak kosong<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-dari-sheet-lain\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: pemformatan bersyarat dari sheet lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kotak-centang-pemformatan-bersyarat-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Pemformatan Bersyarat Berbasis Kotak Centang<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi rumus khusus di Google Spreadsheet untuk menerapkan pemformatan bersyarat pada sel yang tidak cocok dengan nilai tertentu. Contoh berikut memperlihatkan cara menggunakan fungsi rumus kustom dalam praktiknya. Contoh: Cara menggunakan \u201cTidak Sama\u201d dalam pemformatan bersyarat Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet: Misalkan kita ingin menyorot setiap sel di [&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: Gunakan \u201cTidak Merata\u201d dalam Pemformatan Bersyarat \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan &quot;berbeda&quot; dalam pemformatan bersyarat di Google Spreadsheet, dengan 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\/pemformatan-bersyarat-google-sheet-tidak-sama\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Gunakan \u201cTidak Merata\u201d dalam Pemformatan Bersyarat \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan &quot;berbeda&quot; dalam pemformatan bersyarat di Google Spreadsheet, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pemformatan-bersyarat-google-sheet-tidak-sama\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T10:38:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/eq1.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\/pemformatan-bersyarat-google-sheet-tidak-sama\/\",\"url\":\"https:\/\/statorials.org\/id\/pemformatan-bersyarat-google-sheet-tidak-sama\/\",\"name\":\"Google Spreadsheet: Gunakan \u201cTidak Merata\u201d dalam Pemformatan Bersyarat \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T10:38:25+00:00\",\"dateModified\":\"2023-07-15T10:38:25+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan &quot;berbeda&quot; dalam pemformatan bersyarat di Google Spreadsheet, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pemformatan-bersyarat-google-sheet-tidak-sama\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pemformatan-bersyarat-google-sheet-tidak-sama\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pemformatan-bersyarat-google-sheet-tidak-sama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: gunakan \u201ctidak sama\u201d; dalam format bersyarat\"}]},{\"@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: Gunakan \u201cTidak Merata\u201d dalam Pemformatan Bersyarat \u2013 Statorial","description":"Tutorial ini menjelaskan cara menggunakan &quot;berbeda&quot; dalam pemformatan bersyarat di Google Spreadsheet, dengan 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\/pemformatan-bersyarat-google-sheet-tidak-sama\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Gunakan \u201cTidak Merata\u201d dalam Pemformatan Bersyarat \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan &quot;berbeda&quot; dalam pemformatan bersyarat di Google Spreadsheet, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/pemformatan-bersyarat-google-sheet-tidak-sama\/","og_site_name":"Statorials","article_published_time":"2023-07-15T10:38:25+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/eq1.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\/pemformatan-bersyarat-google-sheet-tidak-sama\/","url":"https:\/\/statorials.org\/id\/pemformatan-bersyarat-google-sheet-tidak-sama\/","name":"Google Spreadsheet: Gunakan \u201cTidak Merata\u201d dalam Pemformatan Bersyarat \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T10:38:25+00:00","dateModified":"2023-07-15T10:38:25+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan &quot;berbeda&quot; dalam pemformatan bersyarat di Google Spreadsheet, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pemformatan-bersyarat-google-sheet-tidak-sama\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pemformatan-bersyarat-google-sheet-tidak-sama\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pemformatan-bersyarat-google-sheet-tidak-sama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: gunakan \u201ctidak sama\u201d; dalam format bersyarat"}]},{"@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\/3807"}],"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=3807"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3807\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}