{"id":5130,"date":"2023-07-03T01:27:49","date_gmt":"2023-07-03T01:27:49","guid":{"rendered":"https:\/\/statorials.org\/id\/warna-kolom-alternatif-excel\/"},"modified":"2023-07-03T01:27:49","modified_gmt":"2023-07-03T01:27:49","slug":"warna-kolom-alternatif-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/warna-kolom-alternatif-excel\/","title":{"rendered":"Cara mengganti warna kolom di excel (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Seringkali, Anda mungkin ingin mengganti warna kolom di Excel.<\/span><\/p>\n

Misalnya, Anda mungkin ingin mengganti warna kolom dalam satu lembar sehingga semua kolom lainnya memiliki warna yang sama:<\/span><\/p>\n

Contoh berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n

Contoh: Cara mengganti warna kolom di Excel<\/span><\/strong><\/h2>\n

Katakanlah kita ingin mengganti warna latar belakang yang digunakan di kolom A hingga H lembar Excel kita.<\/span><\/p>\n

Untuk melakukan ini, pertama-tama kita perlu menyorot setiap kolom berikut:<\/span><\/p>\n

Selanjutnya,<\/span> klik menu tarik-turun Pemformatan Bersyarat<\/strong> pada tab Beranda<\/strong> , lalu klik Aturan Baru<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Di jendela baru yang muncul, klik Gunakan rumus untuk menentukan sel mana yang akan diformat<\/strong> , lalu ketik =MOD(COLUMN(),2)=0<\/strong> di dalam kotak, lalu klik tombol Format<\/strong> dan pilih warna isian yang akan digunakan.<\/span><\/p>\n

Setelah kita menekan OK<\/strong> , kolom akan bergantian antara warna latar belakang hijau muda dan tanpa warna latar belakang:<\/span><\/p>\n

Catatan<\/strong> : Kami memilih untuk menggunakan isian hijau muda untuk pemformatan bersyarat dalam contoh ini, namun Anda dapat memilih warna dan gaya apa pun yang Anda inginkan untuk pemformatan bersyarat.<\/span><\/p>\n

Sumber daya tambahan<\/span><\/strong><\/h2>\n

Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n

Excel: Cara mengganti warna baris berdasarkan grup<\/a>
Excel: terapkan pemformatan bersyarat jika sel berisi teks<\/a>
Excel: menerapkan pemformatan bersyarat dengan berbagai kondisi<\/a>
Excel: menerapkan pemformatan bersyarat jika antara dua nilai<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Seringkali, Anda mungkin ingin mengganti warna kolom di Excel. Misalnya, Anda mungkin ingin mengganti warna kolom dalam satu lembar sehingga semua kolom lainnya memiliki warna yang sama: Contoh berikut menunjukkan cara melakukan hal ini. Contoh: Cara mengganti warna kolom di Excel Katakanlah kita ingin mengganti warna latar belakang yang digunakan di kolom A hingga H […]<\/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":"\nCara Mengganti Warna Kolom di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengganti warna kolom di Excel, 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\/warna-kolom-alternatif-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengganti Warna Kolom di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengganti warna kolom di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/warna-kolom-alternatif-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-03T01:27:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/base1.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\/warna-kolom-alternatif-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/warna-kolom-alternatif-excel\/\",\"name\":\"Cara Mengganti Warna Kolom di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-03T01:27:49+00:00\",\"dateModified\":\"2023-07-03T01:27:49+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengganti warna kolom di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/warna-kolom-alternatif-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/warna-kolom-alternatif-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/warna-kolom-alternatif-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengganti warna kolom di excel (dengan contoh)\"}]},{\"@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":"Cara Mengganti Warna Kolom di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara mengganti warna kolom di Excel, 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\/warna-kolom-alternatif-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengganti Warna Kolom di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara mengganti warna kolom di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/warna-kolom-alternatif-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-03T01:27:49+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/base1.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\/warna-kolom-alternatif-excel\/","url":"https:\/\/statorials.org\/id\/warna-kolom-alternatif-excel\/","name":"Cara Mengganti Warna Kolom di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-03T01:27:49+00:00","dateModified":"2023-07-03T01:27:49+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengganti warna kolom di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/warna-kolom-alternatif-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/warna-kolom-alternatif-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/warna-kolom-alternatif-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengganti warna kolom di excel (dengan contoh)"}]},{"@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\/5130"}],"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=5130"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5130\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}