{"id":2794,"date":"2023-07-20T16:24:26","date_gmt":"2023-07-20T16:24:26","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-beberapa-kondisi\/"},"modified":"2023-07-20T16:24:26","modified_gmt":"2023-07-20T16:24:26","slug":"excel-pemformatan-bersyarat-beberapa-kondisi","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-beberapa-kondisi\/","title":{"rendered":"Excel: menerapkan pemformatan bersyarat dengan berbagai kondisi"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menerapkan pemformatan bersyarat ke sel berdasarkan beberapa kondisi di Excel.<\/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 dengan beberapa kondisi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut yang berisi informasi tentang berbagai tim bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24529 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multicondition1.jpg\" alt=\"\" width=\"455\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menyorot setiap nilai pada kolom poin yang nilainya lebih besar dari 10 <em>dan<\/em> kurang dari 20.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, sorot nilai dalam rentang <strong>B2:B14<\/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;\">=IF(AND(B2&gt;10, B2&lt;20), TRUE, FALSE)<\/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=\"aligncenter wp-image-24528\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionnel5.jpg\" alt=\"Pemformatan bersyarat Excel dari berbagai kondisi\" width=\"678\" height=\"391\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap nilai di kolom poin yang lebih besar dari 10 <em>dan<\/em> kurang dari 20 akan disorot secara otomatis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24530 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionnel6.jpg\" alt=\"\" width=\"482\" height=\"418\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi <strong>AND<\/strong> di Excel <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/and-function-5f19b2e8-e1df-4408-897a-ce285a19e9d9\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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\/\">Bagaimana menerapkan pemformatan bersyarat jika sel berisi teks di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menemukan-10-persen-teratas\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan 10% nilai teratas di kolom Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menemukan-10-nilai-pertama\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan 10 nilai teratas dalam daftar di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menemukan-nilai-unik-di-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan nilai unik dari beberapa kolom di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menerapkan pemformatan bersyarat ke sel berdasarkan beberapa kondisi di Excel. Contoh berikut menunjukkan dengan tepat bagaimana melakukan hal ini. Contoh: Pemformatan bersyarat dengan beberapa kondisi Misalkan kita memiliki kumpulan data berikut yang berisi informasi tentang berbagai tim bola basket: Misalkan kita ingin menyorot setiap nilai pada kolom poin yang nilainya lebih [&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 dengan beberapa kondisi - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat pada sel di Excel menggunakan beberapa kondisi, termasuk 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\/excel-pemformatan-bersyarat-beberapa-kondisi\/\" \/>\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 dengan beberapa kondisi - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat pada sel di Excel menggunakan beberapa kondisi, termasuk contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-beberapa-kondisi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T16:24:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multicondition1.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\/excel-pemformatan-bersyarat-beberapa-kondisi\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-beberapa-kondisi\/\",\"name\":\"Excel: menerapkan pemformatan bersyarat dengan beberapa kondisi - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T16:24:26+00:00\",\"dateModified\":\"2023-07-20T16:24:26+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat pada sel di Excel menggunakan beberapa kondisi, termasuk contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-beberapa-kondisi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-beberapa-kondisi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-beberapa-kondisi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: menerapkan 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":"Excel: menerapkan pemformatan bersyarat dengan beberapa kondisi - Statorial","description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat pada sel di Excel menggunakan beberapa kondisi, termasuk 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\/excel-pemformatan-bersyarat-beberapa-kondisi\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: menerapkan pemformatan bersyarat dengan beberapa kondisi - Statorial","og_description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat pada sel di Excel menggunakan beberapa kondisi, termasuk contoh.","og_url":"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-beberapa-kondisi\/","og_site_name":"Statorials","article_published_time":"2023-07-20T16:24:26+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multicondition1.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\/excel-pemformatan-bersyarat-beberapa-kondisi\/","url":"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-beberapa-kondisi\/","name":"Excel: menerapkan pemformatan bersyarat dengan beberapa kondisi - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T16:24:26+00:00","dateModified":"2023-07-20T16:24:26+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat pada sel di Excel menggunakan beberapa kondisi, termasuk contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-beberapa-kondisi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-beberapa-kondisi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-beberapa-kondisi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: menerapkan 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\/2794"}],"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=2794"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2794\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2794"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}