{"id":5069,"date":"2023-07-04T05:40:28","date_gmt":"2023-07-04T05:40:28","guid":{"rendered":"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dengan-warna\/"},"modified":"2023-07-04T05:40:28","modified_gmt":"2023-07-04T05:40:28","slug":"daftar-dropdown-excel-dengan-warna","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dengan-warna\/","title":{"rendered":"Excel: cara membuat daftar drop-down dengan warna"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin membuat daftar drop-down di Excel dengan warna.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Buat data<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki data di Excel tentang jumlah poin yang dicetak oleh seorang pemain bola basket di tim tertentu dan kita ingin memberikan peringkat Baik, OK, atau Buruk kepada pemain tersebut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39508 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/couleurgoutte1.png\" alt=\"\" width=\"438\" height=\"323\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Tetapkan opsi tarik-turun<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, ketik <strong>Good<\/strong> , <strong>OK<\/strong> , dan <strong>Bad<\/strong> pada rentang <strong>F1:F3<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39510 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/couleurgoutte2.png\" alt=\"\" width=\"501\" height=\"339\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini akan digunakan pada langkah berikutnya sebagai opsi potensial yang dapat dipilih dari daftar drop-down.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Buat daftar drop-down<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, pilih sel <strong>C2<\/strong> , lalu klik tab <strong>Data<\/strong> di sepanjang pita atas, lalu klik ikon <strong>Validasi Data<\/strong> di grup <strong>Alat Data<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39509 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/la-validation-des-donnees.png\" alt=\"\" width=\"552\" height=\"193\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada kotak baru yang muncul, pilih <strong>List<\/strong> dari menu drop-down <strong>Allow<\/strong> , lalu pilih <strong>F1:F3<\/strong> untuk <strong>Source<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39511 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/couleurgoutte3.png\" alt=\"\" width=\"582\" height=\"466\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , daftar drop-down akan secara otomatis ditambahkan ke sel <strong>C2<\/strong> dengan Baik, OK, dan Buruk sebagai opsi potensial.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39512 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/couleurgoutte4.png\" alt=\"\" width=\"518\" height=\"335\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong><span style=\"color: #000000;\">Langkah 4: Tambahkan Warna ke Dropdown<\/span><\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, dengan sel <strong>C2<\/strong> dipilih, klik ikon <strong>Pemformatan Bersyarat<\/strong> pada tab <strong>Beranda<\/strong> di sepanjang pita atas, lalu klik <strong>Aturan Baru<\/strong> :<\/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=\"534\" height=\"387\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di kotak baru yang muncul, klik <strong>Format hanya sel yang berisi<\/strong> , lalu pilih <strong>Teks spesifik<\/strong> di bawah kotak <strong>Deskripsi aturan<\/strong> , lalu pilih <strong>=$F$1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik ikon <strong>Format<\/strong> dan pilih warna isian yang akan digunakan. Kami akan memilih hijau:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39513 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/couleurgoutte5.png\" alt=\"\" width=\"665\" height=\"526\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , opsi &#8220;Bagus&#8221; akan diisi dengan latar belakang hijau ketika dipilih dari daftar drop-down:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39514\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/couleurgoutte6.png\" alt=\"Daftar drop-down Excel dengan warna\" width=\"517\" height=\"329\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat mengulangi proses yang sama untuk menentukan latar belakang kuning yang akan digunakan ketika &#8220;OK&#8221; dipilih:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39515 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/couleur7.png\" alt=\"\" width=\"467\" height=\"300\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dan kita dapat mengulangi proses untuk menentukan latar belakang merah yang akan digunakan ketika &#8220;Buruk&#8221; dipilih:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39516 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/couleurgoutte8.png\" alt=\"\" width=\"476\" height=\"346\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami sekarang telah berhasil menambahkan warna ke daftar dropdown kami.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jika Anda mengklik ikon <strong>Conditional Formatting<\/strong> pada tab <strong>Home<\/strong> dan kemudian klik <strong>Manage Rules<\/strong> , Anda akan dapat melihat semua aturan conditional formatting yang telah Anda buat:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39517 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/couleurgoutte9.png\" alt=\"\" width=\"668\" height=\"364\" srcset=\"\" sizes=\"\"><\/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> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/isi-otomatis-excel-dari-daftar\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara mengisi otomatis menggunakan daftar kustom<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sorot-excel-jika-ada-dalam-daftar\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menyorot sel jika nilainya ada dalam 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><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin membuat daftar drop-down di Excel dengan warna. Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini. Langkah 1: Buat data Katakanlah kita memiliki data di Excel tentang jumlah poin yang dicetak oleh seorang pemain bola basket di tim tertentu dan kita ingin memberikan peringkat Baik, OK, atau Buruk kepada pemain [&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 membuat daftar drop-down dengan warna - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat daftar drop-down di Excel dengan warna, dengan contoh langkah demi langkah.\" \/>\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\/daftar-dropdown-excel-dengan-warna\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara membuat daftar drop-down dengan warna - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat daftar drop-down di Excel dengan warna, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dengan-warna\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-04T05:40:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/couleurgoutte1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dengan-warna\/\",\"url\":\"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dengan-warna\/\",\"name\":\"Excel: Cara membuat daftar drop-down dengan warna - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-04T05:40:28+00:00\",\"dateModified\":\"2023-07-04T05:40:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat daftar drop-down di Excel dengan warna, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dengan-warna\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dengan-warna\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dengan-warna\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara membuat daftar drop-down dengan warna\"}]},{\"@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 membuat daftar drop-down dengan warna - Statologi","description":"Tutorial ini menjelaskan cara membuat daftar drop-down di Excel dengan warna, dengan contoh langkah demi langkah.","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\/daftar-dropdown-excel-dengan-warna\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara membuat daftar drop-down dengan warna - Statologi","og_description":"Tutorial ini menjelaskan cara membuat daftar drop-down di Excel dengan warna, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dengan-warna\/","og_site_name":"Statorials","article_published_time":"2023-07-04T05:40:28+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/couleurgoutte1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dengan-warna\/","url":"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dengan-warna\/","name":"Excel: Cara membuat daftar drop-down dengan warna - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-04T05:40:28+00:00","dateModified":"2023-07-04T05:40:28+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat daftar drop-down di Excel dengan warna, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dengan-warna\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/daftar-dropdown-excel-dengan-warna\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dengan-warna\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara membuat daftar drop-down dengan warna"}]},{"@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\/5069"}],"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=5069"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5069\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5069"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5069"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5069"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}