{"id":4101,"date":"2023-07-13T14:25:42","date_gmt":"2023-07-13T14:25:42","guid":{"rendered":"https:\/\/statorials.org\/id\/baris-highlight-excel-berdasarkan-nilai-sel\/"},"modified":"2023-07-13T14:25:42","modified_gmt":"2023-07-13T14:25:42","slug":"baris-highlight-excel-berdasarkan-nilai-sel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/baris-highlight-excel-berdasarkan-nilai-sel\/","title":{"rendered":"Excel: cara menyorot seluruh baris berdasarkan nilai sel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menyorot seluruh baris di Excel berdasarkan nilai sel tertentu di baris tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda mungkin ingin menyorot setiap baris dalam kumpulan data berikut yang nilai dalam kolom <strong>Lulus<\/strong> adalah &#8220;Ya&#8221;:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32610\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/haut4.png\" alt=\"Excel menyoroti baris berdasarkan nilai sel\" width=\"504\" height=\"466\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini mudah dilakukan dengan menggunakan fitur <strong>pemformatan bersyarat<\/strong> Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan bagaimana melakukan hal ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Sorot seluruh baris berdasarkan nilai sel di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang jumlah jam belajar, nilai ujian akhir, dan status kelulusan berbagai siswa di kelas tertentu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32607 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/haut1.png\" alt=\"\" width=\"486\" height=\"441\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin menyorot setiap baris yang nilai pada kolom <strong>Suksesnya<\/strong> adalah &#8220;Ya&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Caranya, kita bisa menyorot cell range <strong>A2:D11<\/strong> , lalu klik ikon <strong>Conditional Formatting<\/strong> , lalu klik <strong>New Rule<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32608 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/haut2.png\" alt=\"\" width=\"523\" height=\"472\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik opsi berjudul <strong>Gunakan rumus untuk menentukan sel mana yang akan diformat<\/strong> , lalu ketik <strong>=$D2=\u201dYes\u201d<\/strong> di dalam kotak, lalu klik tombol <strong>Format<\/strong> dan pilih warna isian yang akan digunakan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32609 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/haut3.png\" alt=\"\" width=\"587\" height=\"424\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , setiap baris yang berisi &#8220;Ya&#8221; di kolom Lulus akan disorot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32610\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/haut4.png\" alt=\"Excel menyoroti baris berdasarkan nilai sel\" width=\"504\" height=\"466\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap baris yang berisi &#8220;Ya&#8221; di kolom <strong>Lulus<\/strong> kini memiliki warna isian hijau muda sementara setiap baris yang berisi &#8220;Tidak&#8221; tetap tidak berubah.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa untuk contoh ini kita memilih untuk menyorot garis menggunakan warna hijau muda, namun Anda dapat memilih warna apa pun yang Anda inginkan dengan memilih warna berbeda menggunakan tombol <strong>Format<\/strong> di jendela <strong>Edit Aturan Pemformatan<\/strong> .<\/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\/filter-excel-berdasarkan-daftar-nilai\/\" target=\"_blank\" rel=\"noopener\">Cara memfilter berdasarkan daftar nilai di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/filter-excel-beberapa-nilai\/\" target=\"_blank\" rel=\"noopener\">Cara memfilter kolom berdasarkan beberapa nilai di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-nilai\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung baris dengan nilai di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menyorot seluruh baris di Excel berdasarkan nilai sel tertentu di baris tersebut. Misalnya, Anda mungkin ingin menyorot setiap baris dalam kumpulan data berikut yang nilai dalam kolom Lulus adalah &#8220;Ya&#8221;: Ini mudah dilakukan dengan menggunakan fitur pemformatan bersyarat Excel. Contoh berikut menunjukkan bagaimana melakukan hal ini dalam praktik. Contoh: Sorot seluruh [&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 seluruh baris berdasarkan nilai sel \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menyorot seluruh baris di Excel berdasarkan nilai sel tertentu di baris tersebut, 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\/baris-highlight-excel-berdasarkan-nilai-sel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menyorot seluruh baris berdasarkan nilai sel \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menyorot seluruh baris di Excel berdasarkan nilai sel tertentu di baris tersebut, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/baris-highlight-excel-berdasarkan-nilai-sel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T14:25:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/haut4.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\/baris-highlight-excel-berdasarkan-nilai-sel\/\",\"url\":\"https:\/\/statorials.org\/id\/baris-highlight-excel-berdasarkan-nilai-sel\/\",\"name\":\"Excel: Cara menyorot seluruh baris berdasarkan nilai sel \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T14:25:42+00:00\",\"dateModified\":\"2023-07-13T14:25:42+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menyorot seluruh baris di Excel berdasarkan nilai sel tertentu di baris tersebut, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/baris-highlight-excel-berdasarkan-nilai-sel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/baris-highlight-excel-berdasarkan-nilai-sel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/baris-highlight-excel-berdasarkan-nilai-sel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menyorot seluruh baris berdasarkan nilai sel\"}]},{\"@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 seluruh baris berdasarkan nilai sel \u2013 Statorial","description":"Tutorial ini menjelaskan cara menyorot seluruh baris di Excel berdasarkan nilai sel tertentu di baris tersebut, 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\/baris-highlight-excel-berdasarkan-nilai-sel\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menyorot seluruh baris berdasarkan nilai sel \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menyorot seluruh baris di Excel berdasarkan nilai sel tertentu di baris tersebut, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/baris-highlight-excel-berdasarkan-nilai-sel\/","og_site_name":"Statorials","article_published_time":"2023-07-13T14:25:42+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/haut4.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\/baris-highlight-excel-berdasarkan-nilai-sel\/","url":"https:\/\/statorials.org\/id\/baris-highlight-excel-berdasarkan-nilai-sel\/","name":"Excel: Cara menyorot seluruh baris berdasarkan nilai sel \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T14:25:42+00:00","dateModified":"2023-07-13T14:25:42+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menyorot seluruh baris di Excel berdasarkan nilai sel tertentu di baris tersebut, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/baris-highlight-excel-berdasarkan-nilai-sel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/baris-highlight-excel-berdasarkan-nilai-sel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/baris-highlight-excel-berdasarkan-nilai-sel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menyorot seluruh baris berdasarkan nilai sel"}]},{"@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\/4101"}],"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=4101"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4101\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4101"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}