{"id":4112,"date":"2023-07-13T12:32:59","date_gmt":"2023-07-13T12:32:59","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-berubah-warna-saat-kotak-centang-dicentang\/"},"modified":"2023-07-13T12:32:59","modified_gmt":"2023-07-13T12:32:59","slug":"google-sheet-berubah-warna-saat-kotak-centang-dicentang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-berubah-warna-saat-kotak-centang-dicentang\/","title":{"rendered":"Google spreadsheet: berubah warna saat kotak dicentang"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fitur <strong>rumus khusus<\/strong> di Google Spreadsheet untuk mengubah warna sel saat kotak centang dicentang.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan fungsi rumus kustom dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Pemformatan bersyarat berdasarkan kotak centang<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki dataset berikut di Google Sheets yang berisi nama-nama daftar siswa dan lulus atau tidaknya ujian akhir di kelas tertentu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32670 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/co1-1.png\" alt=\"\" width=\"497\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menyorot nama siswa dengan warna hijau jika kotak pada kolom terkait dicentang.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita dapat mengklik tab <strong>Format<\/strong> , lalu <strong>Conditional Formatting<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32671 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/co2.png\" alt=\"\" width=\"549\" height=\"477\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di panel <strong>Conditional Format Rules<\/strong> yang muncul di sisi kanan layar, ketik <strong>A2:A11<\/strong> di kotak berlabel <strong>Apply to Range<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Lalu pilih <strong>Rumus khusus<\/strong> di menu tarik-turun di bawah <strong>Format sel jika\u2026<\/strong> lalu ketik rumus berikut di dalam kotak:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=$B2=TRUE()\n<\/strong><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32672 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/co3.png\" alt=\"\" width=\"322\" height=\"645\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>Selesai<\/strong> , setiap sel di kolom A dengan kotak centang di kolom B akan otomatis disorot dengan warna hijau:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32673 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/co4.png\" alt=\"\" width=\"490\" height=\"481\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda kemudian mencentang kotak baru, seperti yang ada di sebelah Siswa J, nama siswa tersebut secara otomatis akan disorot dengan warna hijau:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32674 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/co5.png\" alt=\"\" width=\"497\" height=\"485\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan #1<\/strong> : Di Google Spreadsheet, jika kotak centang dicentang, sel tersebut memiliki nilai dasar TRUE, itulah sebabnya kami menggunakan rumus <strong>=$B2=TRUE()<\/strong> untuk menentukan apakah kotak centang dicentang.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan #2<\/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 dengan mengeklik ikon ember cat di bawah area <strong>Gaya 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 Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/jumlah-google-sheet-jika-kotak-centang-dicentang\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: cara menambahkan jika kotak dicentang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kotak-centang-pemformatan-bersyarat-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Pemformatan Bersyarat Berbasis Kotak Centang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bilah-kotak-centang-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: tambahkan coretan ketika kotak dicentang<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fitur rumus khusus di Google Spreadsheet untuk mengubah warna sel saat kotak centang dicentang. Contoh berikut memperlihatkan cara menggunakan fungsi rumus kustom dalam praktiknya. Contoh: Pemformatan bersyarat berdasarkan kotak centang Katakanlah kita memiliki dataset berikut di Google Sheets yang berisi nama-nama daftar siswa dan lulus atau tidaknya ujian akhir di kelas tertentu: [&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>Google Sheets: berubah warna ketika kotak dicentang - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah warna sel di Google Sheets ketika kotak centang dicentang.\" \/>\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\/google-sheet-berubah-warna-saat-kotak-centang-dicentang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets: berubah warna ketika kotak dicentang - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah warna sel di Google Sheets ketika kotak centang dicentang.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-berubah-warna-saat-kotak-centang-dicentang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T12:32:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/co1-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\/google-sheet-berubah-warna-saat-kotak-centang-dicentang\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-berubah-warna-saat-kotak-centang-dicentang\/\",\"name\":\"Google Sheets: berubah warna ketika kotak dicentang - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T12:32:59+00:00\",\"dateModified\":\"2023-07-13T12:32:59+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah warna sel di Google Sheets ketika kotak centang dicentang.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-berubah-warna-saat-kotak-centang-dicentang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-berubah-warna-saat-kotak-centang-dicentang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-berubah-warna-saat-kotak-centang-dicentang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: berubah warna saat kotak dicentang\"}]},{\"@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":"Google Sheets: berubah warna ketika kotak dicentang - Statorials","description":"Tutorial ini menjelaskan cara mengubah warna sel di Google Sheets ketika kotak centang dicentang.","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\/google-sheet-berubah-warna-saat-kotak-centang-dicentang\/","og_locale":"id_ID","og_type":"article","og_title":"Google Sheets: berubah warna ketika kotak dicentang - Statorials","og_description":"Tutorial ini menjelaskan cara mengubah warna sel di Google Sheets ketika kotak centang dicentang.","og_url":"https:\/\/statorials.org\/id\/google-sheet-berubah-warna-saat-kotak-centang-dicentang\/","og_site_name":"Statorials","article_published_time":"2023-07-13T12:32:59+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/co1-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\/google-sheet-berubah-warna-saat-kotak-centang-dicentang\/","url":"https:\/\/statorials.org\/id\/google-sheet-berubah-warna-saat-kotak-centang-dicentang\/","name":"Google Sheets: berubah warna ketika kotak dicentang - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T12:32:59+00:00","dateModified":"2023-07-13T12:32:59+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah warna sel di Google Sheets ketika kotak centang dicentang.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-berubah-warna-saat-kotak-centang-dicentang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-berubah-warna-saat-kotak-centang-dicentang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-berubah-warna-saat-kotak-centang-dicentang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: berubah warna saat kotak dicentang"}]},{"@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\/4112"}],"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=4112"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4112\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}