{"id":4485,"date":"2023-07-10T17:39:37","date_gmt":"2023-07-10T17:39:37","guid":{"rendered":"https:\/\/statorials.org\/id\/sorot-excel-jika-ada-dalam-daftar\/"},"modified":"2023-07-10T17:39:37","modified_gmt":"2023-07-10T17:39:37","slug":"sorot-excel-jika-ada-dalam-daftar","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sorot-excel-jika-ada-dalam-daftar\/","title":{"rendered":"Excel: cara menyorot sel jika nilainya ada dalam daftar"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menyorot sel di Excel jika sel tersebut berisi nilai yang ada dalam daftar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan dengan menggunakan fitur <strong>Aturan Baru<\/strong> di Opsi <strong>Pemformatan Bersyarat<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara menyorot sel jika nilainya ada dalam daftar<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki dua daftar tim bola basket berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35089 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/generation-1.png\" alt=\"\" width=\"470\" height=\"427\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menyorot setiap sel di daftar <strong>Semua Tim<\/strong> yang ada di daftar <strong>Tim Baik<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita dapat menyorot rentang sel <strong>A2:A11<\/strong> , lalu klik ikon <strong>pemformatan bersyarat<\/strong> di tab <strong>Beranda<\/strong> di sepanjang pita atas, lalu klik <strong>Aturan Baru<\/strong> di menu tarik-turun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35090 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/etat-neuf1.png\" alt=\"\" width=\"514\" height=\"372\" 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:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTIF($C$2:$C$6,A2)&gt;0<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kemudian klik tombol <strong>Format<\/strong> dan pilih warna yang akan digunakan untuk pemformatan bersyarat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami akan memilih hijau muda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35091 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/generation-2.png\" alt=\"\" width=\"596\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, klik <strong>OK<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Setiap sel di daftar <strong>Semua Tim<\/strong> yang ada di daftar <strong>Tim Baik<\/strong> akan otomatis disorot dengan warna hijau muda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-35092\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gen3.png\" alt=\"Sorot Excel jika ada dalam daftar\" width=\"479\" height=\"423\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Dalam contoh ini, kami memilih untuk menggunakan isian hijau muda untuk pemformatan sel bersyarat, namun Anda dapat memilih warna isian apa pun yang Anda inginkan.<\/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 Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-berisi-teks-daftar\/\" target=\"_blank\" rel=\"noopener\">Excel: cara memeriksa apakah sel berisi teks daftar<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/unggul-jika-dalam-daftar-maka-ya\/\" target=\"_blank\" rel=\"noopener\">Excel: cari nilai dalam daftar dan kembalikan ya atau tidak<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-cocokkan-dua-kolom-kembalikan-ketiga\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Mencocokkan Dua Kolom dan Mengembalikan Kolom Ketiga<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menyorot sel di Excel jika sel tersebut berisi nilai yang ada dalam daftar. Untungnya, hal ini mudah dilakukan dengan menggunakan fitur Aturan Baru di Opsi Pemformatan Bersyarat . Contoh berikut menunjukkan cara melakukan hal ini. Contoh: Cara menyorot sel jika nilainya ada dalam daftar Misalkan kita memiliki dua daftar tim bola [&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: Cara menyorot sel jika ada nilai dalam daftar - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menyorot sel di Excel jika nilainya ada dalam daftar, 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\/sorot-excel-jika-ada-dalam-daftar\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menyorot sel jika ada nilai dalam daftar - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menyorot sel di Excel jika nilainya ada dalam daftar, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sorot-excel-jika-ada-dalam-daftar\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T17:39:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/generation-1.png\" \/>\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\/sorot-excel-jika-ada-dalam-daftar\/\",\"url\":\"https:\/\/statorials.org\/id\/sorot-excel-jika-ada-dalam-daftar\/\",\"name\":\"Excel: Cara menyorot sel jika ada nilai dalam daftar - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T17:39:37+00:00\",\"dateModified\":\"2023-07-10T17:39:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menyorot sel di Excel jika nilainya ada dalam daftar, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sorot-excel-jika-ada-dalam-daftar\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sorot-excel-jika-ada-dalam-daftar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sorot-excel-jika-ada-dalam-daftar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menyorot sel jika nilainya ada dalam daftar\"}]},{\"@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: Cara menyorot sel jika ada nilai dalam daftar - Statorial","description":"Tutorial ini menjelaskan cara menyorot sel di Excel jika nilainya ada dalam daftar, 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\/sorot-excel-jika-ada-dalam-daftar\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menyorot sel jika ada nilai dalam daftar - Statorial","og_description":"Tutorial ini menjelaskan cara menyorot sel di Excel jika nilainya ada dalam daftar, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/sorot-excel-jika-ada-dalam-daftar\/","og_site_name":"Statorials","article_published_time":"2023-07-10T17:39:37+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/generation-1.png"}],"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\/sorot-excel-jika-ada-dalam-daftar\/","url":"https:\/\/statorials.org\/id\/sorot-excel-jika-ada-dalam-daftar\/","name":"Excel: Cara menyorot sel jika ada nilai dalam daftar - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T17:39:37+00:00","dateModified":"2023-07-10T17:39:37+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menyorot sel di Excel jika nilainya ada dalam daftar, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sorot-excel-jika-ada-dalam-daftar\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sorot-excel-jika-ada-dalam-daftar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sorot-excel-jika-ada-dalam-daftar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menyorot sel jika nilainya ada dalam daftar"}]},{"@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\/4485"}],"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=4485"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4485\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4485"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}