{"id":1761,"date":"2023-11-06T17:36:48","date_gmt":"2023-11-06T17:36:48","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/"},"modified":"2023-12-06T06:20:21","modified_gmt":"2023-12-06T06:20:21","slug":"tidak-bekerja","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/","title":{"rendered":"Kapan pemformatan bersyarat berfungsi?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2484987074\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Di Excel, saat Anda menggunakan pemformatan bersyarat, kemungkinan besar Anda menerapkannya, tetapi tidak berhasil. Dan dalam situasi ini, Anda perlu memecahkan masalah pemformatan yang Anda gunakan.<\/p><p> Saat menerapkan pemformatan bersyarat yang telah ditentukan sebelumnya, Anda mungkin tidak mengalami masalah, tetapi saat menggunakan rumus khusus, ada kemungkinannya.<\/p><h2 class=\"wp-block-heading\"> Referensi yang salah<\/h2><p> Saat Anda menerapkan pemformatan bersyarat menggunakan rumus, Anda mungkin tidak sengaja merujuk ke sel lain. Lihat contoh di bawah ini: Rentang tempat saya ingin menerapkan aturan pemformatan bersyarat adalah A2:A12. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90934\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-reference-erronee.png\" sizes=\"auto, \" srcset=\"\" alt=\"referensi yang salah\" width=\"674\" height=\"419\"><\/figure><\/div><p> Dan rumusnya harus merujuk ke sel A2, bukan A1. Dan karena saya mereferensikan A1 dalam rumusnya, aturan yang diterapkan salah.<\/p><p> Anda dapat melihat bahwa kondisi tersebut menguji apakah nilainya lebih besar dari 1200 atau tidak, dan di dalam sel itu menyorot sel meskipun nilainya tidak lebih besar dari 1200. Semua ini karena referensi yang salah.<\/p><p> Saat bekerja dengan pemformatan bersyarat, salah satu alasan utama mengapa ini tidak berfungsi adalah referensi yang buruk.<\/p><h2 class=\"wp-block-heading\"> Hasil dari kondisi tersebut harus TRUE atau FALSE<\/h2><p> Saat Anda menggunakan rumus dalam format bersyarat, hasil rumus tersebut harus TRUE atau FALSE. Maka hanya pemformatan bersyarat yang akan berfungsi. Hasilnya harus selalu TRUE atau FALSE jika menggunakan OPERATOR LOGIS.<\/p><h2 class=\"wp-block-heading\"> Saat menyalin dan menempelkan pemformatan bersyarat<\/h2><p> Jika Anda memiliki referensi absolut dalam rumus dan mencoba menyalin dan menempelkan pemformatan bersyarat ke dalam sel atau rentang sel baru, format akan diterapkan dengan Kondisi yang salah. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90935\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-copier-et-coller-la-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"salin-tempel-format bersyarat\" width=\"614\" height=\"381\"><\/figure><\/div><p> Pada contoh di atas, acuan kita bersifat mutlak; Anda dapat melihat tanda dolar. Dan ketika Anda mencoba menyalin dan menempelkan pemformatan bersyarat ini ke tempat baru, itu akan selalu merujuk ke sel A2.<\/p><h2 class=\"wp-block-heading\"> Ketika angka diformat sebagai teks<\/h2><p> Jika Anda menggunakan aturan pemformatan bersyarat yang mana aturan tersebut harus memeriksa kondisi suatu angka, angka tersebut memiliki format teks. Dalam hal ini, aturan pemformatan bersyarat ini tidak akan berfungsi dengan benar. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90936\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-lorsque-les-nombres-sont-formates-en-tant-que-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"kapan-angka-diformat-menjadi-teks\" width=\"668\" height=\"494\"><\/figure><\/div><p> Pada contoh di atas, kolom A dan B memiliki aturan pemformatan bersyarat yang sama, yaitu menguji angka yang lebih besar dari 1200. Namun di kolom B, angka tersebut dimasukkan sebagai teks dan format aturan menyorot semua angka.<\/p><p> Dibandingkan dengan ini, di kolom A, tempat angka disimpan sebagai angka, pemformatan bersyarat berfungsi dengan baik. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/la-mise-en-forme-conditionnelle-ne-fonctionne-pas.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-6076ba72 gb-container-mt\"> <a class=\"gb-button gb-button-76e6a499 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/dasar-dasar-excel\/\">Pelajari dasar-dasar Excel<\/a><h2 class=\"gb-headline gb-headline-a9e9e206 gb-headline-text gb-headline-mt-heading\"> Pelajari lebih lanjut tentang <a href=\"https:\/\/exceladvisor.org\/id\/pemformatan-bersyarat\/\">pemformatan bersyarat<\/a> <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-790317cb gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-a9845ede\"><div class=\"gb-container gb-container-a9845ede\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menerapkan-pemformatan-bersyarat\/\">Terapkan pemformatan bersyarat ke tabel pivot<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menarik\/\">Hapus Pemformatan Bersyarat<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sel-kosong\/\">Terapkan Pemformatan Bersyarat pada Sel Kosong di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/\">Bandingkan dua kolom menggunakan pemformatan bersyarat<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-ec8ff319\"><div class=\"gb-container gb-container-ec8ff319\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1761","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Kapan pemformatan bersyarat tidak berfungsi di Excel?<\/title>\n<meta name=\"description\" content=\"Tutorial ini membantu Anda menentukan apakah pemformatan bersyarat berfungsi di file Excel Anda. Mari kita periksa ini...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kapan pemformatan bersyarat tidak berfungsi di Excel?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini membantu Anda menentukan apakah pemformatan bersyarat berfungsi di file Excel Anda. Mari kita periksa ini...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:20:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-reference-erronee.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/\",\"name\":\"Kapan pemformatan bersyarat tidak berfungsi di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-reference-erronee.png\",\"datePublished\":\"2023-11-06T17:36:48+00:00\",\"dateModified\":\"2023-12-06T06:20:21+00:00\",\"description\":\"Tutorial ini membantu Anda menentukan apakah pemformatan bersyarat berfungsi di file Excel Anda. Mari kita periksa ini...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-reference-erronee.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-reference-erronee.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kapan pemformatan bersyarat berfungsi?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Kapan pemformatan bersyarat tidak berfungsi di Excel?","description":"Tutorial ini membantu Anda menentukan apakah pemformatan bersyarat berfungsi di file Excel Anda. Mari kita periksa ini...","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:\/\/exceladvisor.org\/id\/tidak-bekerja\/","og_locale":"id_ID","og_type":"article","og_title":"Kapan pemformatan bersyarat tidak berfungsi di Excel?","og_description":"Tutorial ini membantu Anda menentukan apakah pemformatan bersyarat berfungsi di file Excel Anda. Mari kita periksa ini...","og_url":"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:20:21+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-reference-erronee.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/","url":"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/","name":"Kapan pemformatan bersyarat tidak berfungsi di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-reference-erronee.png","datePublished":"2023-11-06T17:36:48+00:00","dateModified":"2023-12-06T06:20:21+00:00","description":"Tutorial ini membantu Anda menentukan apakah pemformatan bersyarat berfungsi di file Excel Anda. Mari kita periksa ini...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/tidak-bekerja\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-reference-erronee.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-reference-erronee.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Kapan pemformatan bersyarat berfungsi?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1761","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1761"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1761\/revisions"}],"predecessor-version":[{"id":2913,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1761\/revisions\/2913"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}