{"id":2795,"date":"2023-07-20T16:18:09","date_gmt":"2023-07-20T16:18:09","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-antara-dua-nilai\/"},"modified":"2023-07-20T16:18:09","modified_gmt":"2023-07-20T16:18:09","slug":"excel-pemformatan-bersyarat-antara-dua-nilai","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-antara-dua-nilai\/","title":{"rendered":"Excel: menerapkan pemformatan bersyarat jika antara dua nilai"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menerapkan pemformatan bersyarat ke sel yang nilainya berada di antara dua nilai tertentu 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 jika antara dua nilai<\/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=\"469\" height=\"419\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menyorot setiap nilai pada kolom poin yang nilainya antara 10 dan 20.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Caranya, sorot nilai dalam rentang <strong>B2:B14<\/strong> , lalu klik ikon <strong>Conditional Formatting<\/strong> pada tab <strong>Beranda<\/strong> , lalu klik <strong>Sorot Aturan Sel<\/strong> , lalu <strong>Enter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24536 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionnel-entre.jpg\" alt=\"\" width=\"611\" height=\"461\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, pilih 10 sebagai nilai terendah dan 20 sebagai nilai tertinggi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24537 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionnel-entre-1.jpg\" alt=\"\" width=\"632\" height=\"422\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , nilai kolom titik antara 10 dan 20 secara otomatis akan diformat dengan latar belakang merah terang dan teks merah tua:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24538 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionnel-entre-2.jpg\" alt=\"\" width=\"455\" height=\"399\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa Anda juga dapat memilih format sel yang berbeda.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Misalnya, Anda bisa memilih untuk memformat sel menggunakan latar belakang hijau dengan teks hijau tua:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24539\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionnel-entre-3.jpg\" alt=\"pemformatan bersyarat antara dua nilai di Excel\" width=\"639\" height=\"420\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Anda juga dapat memilih <strong>Format Kustom<\/strong> untuk menentukan gaya format khusus untuk sel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24541 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionnel-entre-4.jpg\" alt=\"\" width=\"465\" height=\"205\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini memungkinkan Anda memilih kombinasi gaya apa pun yang Anda inginkan untuk warna latar belakang dan warna teks.<\/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-pemformatan-bersyarat-beberapa-kondisi\/\" target=\"_blank\" rel=\"noopener\">Bagaimana menerapkan pemformatan bersyarat dengan beberapa kondisi di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menerapkan pemformatan bersyarat ke sel yang nilainya berada di antara dua nilai tertentu di Excel. Contoh berikut menunjukkan dengan tepat bagaimana melakukan hal ini. Contoh: pemformatan bersyarat jika antara dua nilai Misalkan kita memiliki kumpulan data berikut yang berisi informasi tentang berbagai tim bola basket: Misalkan kita ingin menyorot setiap nilai [&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 antara dua nilai \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat pada sel di Excel antara dua nilai tertentu, 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\/excel-pemformatan-bersyarat-antara-dua-nilai\/\" \/>\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 antara dua nilai \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat pada sel di Excel antara dua nilai tertentu, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-antara-dua-nilai\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T16:18:09+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-antara-dua-nilai\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-antara-dua-nilai\/\",\"name\":\"Excel: menerapkan pemformatan bersyarat jika antara dua nilai \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T16:18:09+00:00\",\"dateModified\":\"2023-07-20T16:18:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat pada sel di Excel antara dua nilai tertentu, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-antara-dua-nilai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-antara-dua-nilai\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-antara-dua-nilai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: menerapkan pemformatan bersyarat jika antara dua nilai\"}]},{\"@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 antara dua nilai \u2013 Statorials","description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat pada sel di Excel antara dua nilai tertentu, 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\/excel-pemformatan-bersyarat-antara-dua-nilai\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: menerapkan pemformatan bersyarat jika antara dua nilai \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat pada sel di Excel antara dua nilai tertentu, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-antara-dua-nilai\/","og_site_name":"Statorials","article_published_time":"2023-07-20T16:18:09+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-antara-dua-nilai\/","url":"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-antara-dua-nilai\/","name":"Excel: menerapkan pemformatan bersyarat jika antara dua nilai \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T16:18:09+00:00","dateModified":"2023-07-20T16:18:09+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menerapkan pemformatan bersyarat pada sel di Excel antara dua nilai tertentu, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-antara-dua-nilai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-antara-dua-nilai\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-antara-dua-nilai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: menerapkan pemformatan bersyarat jika antara dua nilai"}]},{"@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\/2795"}],"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=2795"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2795\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2795"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2795"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2795"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}