{"id":2796,"date":"2023-07-20T16:09:12","date_gmt":"2023-07-20T16:09:12","guid":{"rendered":"https:\/\/statorials.org\/id\/format-kondisional-excel-tidak-sama\/"},"modified":"2023-07-20T16:09:12","modified_gmt":"2023-07-20T16:09:12","slug":"format-kondisional-excel-tidak-sama","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/format-kondisional-excel-tidak-sama\/","title":{"rendered":"Excel: terapkan pemformatan bersyarat jika dua sel tidak sama"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menerapkan pemformatan bersyarat ke dua sel di Excel jika nilainya tidak sama.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan dengan tepat bagaimana melakukan hal ini.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Pemformatan bersyarat jika dua sel tidak sama<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai daftar berikut di Excel yang masing-masing berisi nama 10 siswa:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24547 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ne0.jpg\" alt=\"\" width=\"412\" height=\"409\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menyorot garis yang kedua namanya tidak sama antar kelas.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, sorot nilai dalam rentang <strong>A2:B11<\/strong> , lalu klik ikon <strong>Pemformatan Bersyarat<\/strong> pada tab <strong>Beranda<\/strong> , lalu klik <strong>Aturan Baru<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24519 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionnel.jpg\" alt=\"\" width=\"523\" height=\"395\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik <strong>Gunakan rumus untuk menentukan sel mana yang akan diformat<\/strong> , lalu masukkan rumus berikut ke dalam kotak:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span style=\"color: #000000;\">=$A2 &lt;&gt; $B2<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kemudian klik tombol <strong>Format<\/strong> dan pilih warna isian yang akan digunakan, lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24548 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ne1-2.jpg\" alt=\"\" width=\"598\" height=\"381\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap baris yang namanya tidak sama akan otomatis disorot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24549 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ne2.jpg\" alt=\"\" width=\"472\" height=\"426\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa rumus ini <strong>tidak peka huruf besar-kecil<\/strong> . Artinya jika kita memiliki &#8220;John&#8221; di satu kolom dan &#8220;John&#8221; di kolom lainnya, rumusnya akan mengasumsikan bahwa nilai-nilai tersebut sama.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, Anda bisa menggunakan rumus berikut untuk menerapkan penelusuran <strong>peka huruf besar-kecil<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span style=\"color: #000000;\">=NOT(EXACT($A2,$B2))\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini berarti bahwa jika kita memiliki &#8220;john&#8221; di satu kolom dan &#8220;John&#8221; di kolom lainnya, rumus akan mengasumsikan bahwa nilai-nilai ini <em>tidak<\/em> sama dan menerapkan pemformatan bersyarat pada nilai-nilai tersebut.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/pemformatan-bersyarat-excel-jika-sel-berisi-teks\/\">Excel: terapkan pemformatan bersyarat jika sel berisi teks<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-beberapa-kondisi\/\" target=\"_blank\" rel=\"noopener\">Excel: menerapkan pemformatan bersyarat dengan berbagai kondisi<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-antara-dua-nilai\/\" target=\"_blank\" rel=\"noopener\">Excel: menerapkan pemformatan bersyarat jika antara dua nilai<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menerapkan pemformatan bersyarat ke dua sel di Excel jika nilainya tidak sama. Contoh berikut menunjukkan dengan tepat bagaimana melakukan hal ini. Contoh: Pemformatan bersyarat jika dua sel tidak sama Misalkan kita mempunyai daftar berikut di Excel yang masing-masing berisi nama 10 siswa: Misalkan kita ingin menyorot garis yang kedua namanya tidak [&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>Excel: menerapkan pemformatan bersyarat jika dua sel tidak sama \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat pada sel di Excel jika dua sel tertentu tidak sama.\" \/>\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\/format-kondisional-excel-tidak-sama\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: menerapkan pemformatan bersyarat jika dua sel tidak sama \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat pada sel di Excel jika dua sel tertentu tidak sama.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/format-kondisional-excel-tidak-sama\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T16:09:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ne0.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\/format-kondisional-excel-tidak-sama\/\",\"url\":\"https:\/\/statorials.org\/id\/format-kondisional-excel-tidak-sama\/\",\"name\":\"Excel: menerapkan pemformatan bersyarat jika dua sel tidak sama \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T16:09:12+00:00\",\"dateModified\":\"2023-07-20T16:09:12+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat pada sel di Excel jika dua sel tertentu tidak sama.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/format-kondisional-excel-tidak-sama\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/format-kondisional-excel-tidak-sama\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/format-kondisional-excel-tidak-sama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: terapkan pemformatan bersyarat jika dua sel tidak sama\"}]},{\"@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":"Excel: menerapkan pemformatan bersyarat jika dua sel tidak sama \u2013 Statorial","description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat pada sel di Excel jika dua sel tertentu tidak sama.","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\/format-kondisional-excel-tidak-sama\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: menerapkan pemformatan bersyarat jika dua sel tidak sama \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat pada sel di Excel jika dua sel tertentu tidak sama.","og_url":"https:\/\/statorials.org\/id\/format-kondisional-excel-tidak-sama\/","og_site_name":"Statorials","article_published_time":"2023-07-20T16:09:12+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ne0.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\/format-kondisional-excel-tidak-sama\/","url":"https:\/\/statorials.org\/id\/format-kondisional-excel-tidak-sama\/","name":"Excel: menerapkan pemformatan bersyarat jika dua sel tidak sama \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T16:09:12+00:00","dateModified":"2023-07-20T16:09:12+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat pada sel di Excel jika dua sel tertentu tidak sama.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/format-kondisional-excel-tidak-sama\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/format-kondisional-excel-tidak-sama\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/format-kondisional-excel-tidak-sama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: terapkan pemformatan bersyarat jika dua sel tidak sama"}]},{"@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\/2796"}],"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=2796"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2796\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2796"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2796"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2796"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}