{"id":1795,"date":"2023-11-04T15:49:03","date_gmt":"2023-11-04T15:49:03","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/"},"modified":"2023-12-06T06:21:00","modified_gmt":"2023-12-06T06:21:00","slug":"berdasarkan-tanggal-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/","title":{"rendered":"Terapkan pemformatan bersyarat berdasarkan tanggal"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-95240868\"><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>Dengan pemformatan bersyarat di Excel, Anda bisa menggunakan tanggal untuk membuat aturan untuk menyorot sel. Ada aturan yang telah ditentukan sebelumnya yang dapat Anda gunakan untuk menyorot sel dengan cepat. Dan ada juga cara untuk membuat aturan khusus berdasarkan tanggal. Dalam tutorial ini, kita mempelajari cara menggunakan kedua metode secara detail.<\/p><h2 class=\"wp-block-heading\"> Langkah-langkah Menggunakan Tanggal untuk Pemformatan Bersyarat<\/h2><ol type=\"1\"><li> Pilih data di mana Anda memiliki tanggal.<\/li><li> Buka Beranda &gt; Pemformatan Bersyarat &gt; Aturan Penyorotan Sel.<\/li><li> Dari sana, klik opsi \u201cTanggal Terjadi\u201d.<\/li><li> Di kotak dialog, pilih aturan yang ingin Anda gunakan.<\/li><li> Pada akhirnya, klik OK untuk mendaftar. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-91249\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-une-mise-en-forme-conditionnelle-basee-sur-une-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"terapkan-pemformatan-bersyarat-berdasarkan-tanggal\" width=\"538\" height=\"664\"><\/figure><\/div><p> Dan saat Anda mengklik OK, itu menyorot semua sel tempat Anda memiliki tanggal bulan saat ini. Dengan kotak dialog yang sama, Anda memiliki lebih banyak pilihan untuk digunakan dengan tanggal. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-91250\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-date-apparaissant-dans-le-mois-en-cours-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"pemformatan-bersyarat-tanggal-terjadi-di-bulan ini\" width=\"454\" height=\"282\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Buat aturan khusus berdasarkan tanggal<\/h2><p> Mungkin ada situasi di mana Anda perlu menerapkan aturan pemformatan bersyarat, namun aturan seperti itu tidak ada. Nah, Anda bisa membuat aturan khusus dengan rumus. Buka Beranda &gt; Pemformatan Bersyarat &gt; Aturan Baru.<\/p><h3 class=\"wp-block-heading\"> Sorot tanggal yang lebih lama dari 30 hari, 60 hari, dan 90 hari<\/h3><ol type=\"1\"><li> Pertama, pilih data, buka kotak dialog Aturan Baru dan klik \u201cGunakan rumus untuk menentukan sel mana yang akan diformat\u201d.<ul><li> 30 hari lagi: =$A1&lt;=(HARI INI()-30)<\/li><li> 60 hari lagi: =$A1&lt;=(HARI INI()-60)<\/li><li> 90 hari lagi: =$A1&lt;=(HARI INI()-90)<\/li><\/ul><\/li><li> Setelah itu, untuk menentukan format, klik tombol \u201cFormat\u201d.<\/li><li> Kemudian tentukan format, warna sel, warna font, atau tebal atau miring.<\/li><li> Pada akhirnya, klik OK. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-91251\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-regles-personnalisees-basees-sur-la-mise-en-forme-conditionnelle-des-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"format-aturan-adat-berdasarkan-tanggal-bersyarat\" width=\"683\" height=\"320\"><\/figure><\/div><p> Anda dapat melihat pada contoh di atas bahwa kami menggunakan rumus untuk menyorot tanggal yang lebih lama dari 30 hari dari tanggal saat ini.<\/p><h3 class=\"wp-block-heading\"> Sorot akhir pekan dan tanggal akhir pekan<\/h3><p> Dan dengan menggunakan rumus (Hari dalam Seminggu), Anda dapat menyorot tanggal yang merupakan akhir pekan. Anda dapat melihat pada contoh di bawah bahwa rumus yang kami gunakan menyorot dua tanggal. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=WEEKDAY($A1,2)&gt;5<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-91252\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-dates-en-surbrillance-qui-sont-des-week-ends-formatage-conditionnel.png\" sizes=\"auto, \" srcset=\"\" alt=\"sorot-tanggal-yang-akhir pekan-format bersyarat\" width=\"694\" height=\"360\"><\/figure><\/div><p> Dan jika Anda ingin menyorot hari dalam seminggu, gunakan rumus di bawah ini. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=WEEKDAY($A1,2)&lt;5<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-91253\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-mettre-en-evidence-la-mise-en-forme-conditionnelle-des-jours-de-la-semaine.png\" sizes=\"auto, \" srcset=\"\" alt=\"pemformatan bersyarat dari hari-hari yang disorot dalam seminggu\" width=\"686\" height=\"334\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Rentang tanggal<\/h2><p> Demikian pula, jika Anda ingin menyorot sel berdasarkan rentang tanggal, Anda bisa menggunakan fungsi AND untuk membuat rumus dengan dua kondisi. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-91254\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-cellules-de-surbrillance-basees-sur-une-mise-en-forme-conditionnelle-de-plage-de-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"sorot sel berdasarkan pemformatan bersyarat rentang tanggal\" width=\"655\" height=\"310\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=AND(A1&gt;=(TODAY()-45),A1&lt;=(TODAY()-30))<\/code><\/pre><p> Pada contoh di atas, kami membuat rentang 15 hari. 30 hari dari tanggal sekarang dan 45 hari dari tanggal sekarang.<\/p><h2 class=\"wp-block-heading\"> Gunakan tanggal dari sel lain<\/h2><p> Sekarang jika Anda ingin menggunakan tanggal dalam sel, Anda perlu merujuk ke sel tempat Anda memiliki tanggal tersebut. Lihat contoh di bawah ini; kami menentukan sel C1, di mana kami memiliki tanggalnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-91255\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-date-dune-autre-mise-en-forme-conditionnelle-de-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"tanggal-dari-sel-lain-pemformatan bersyarat\" width=\"675\" height=\"327\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=IF($C$1&lt;&gt;\"\",$A1&gt;=$C$1,FALSE)<\/code><\/pre><p> Dengan cara ini Anda bisa membuat aturan dinamis, dan mengubah tanggal di sel juga akan mengubah sel yang disorot. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-91256\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-changer-la-date-dans-la-mise-en-forme-conditionnelle-de-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"ubah-tanggal-dalam-sel-pemformatan bersyarat\" width=\"376\" height=\"310\"><\/figure><\/div><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\/11\/base-sur-la-date.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><li> <a href=\"https:\/\/exceladvisor.org\/id\/sel-lain\/\">Terapkan pemformatan bersyarat berdasarkan sel lain<\/a><\/li><\/ul><\/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-1795","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>Terapkan pemformatan bersyarat berdasarkan tanggal<\/title>\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\/berdasarkan-tanggal-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Terapkan pemformatan bersyarat berdasarkan tanggal\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:21:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-une-mise-en-forme-conditionnelle-basee-sur-une-date.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\/berdasarkan-tanggal-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/\",\"name\":\"Terapkan pemformatan bersyarat berdasarkan tanggal\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-une-mise-en-forme-conditionnelle-basee-sur-une-date.png\",\"datePublished\":\"2023-11-04T15:49:03+00:00\",\"dateModified\":\"2023-12-06T06:21:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-une-mise-en-forme-conditionnelle-basee-sur-une-date.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-une-mise-en-forme-conditionnelle-basee-sur-une-date.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Terapkan pemformatan bersyarat berdasarkan tanggal\"}]},{\"@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":"Terapkan pemformatan bersyarat berdasarkan tanggal","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\/berdasarkan-tanggal-2\/","og_locale":"id_ID","og_type":"article","og_title":"Terapkan pemformatan bersyarat berdasarkan tanggal","og_url":"https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:21:00+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-une-mise-en-forme-conditionnelle-basee-sur-une-date.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\/berdasarkan-tanggal-2\/","url":"https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/","name":"Terapkan pemformatan bersyarat berdasarkan tanggal","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-une-mise-en-forme-conditionnelle-basee-sur-une-date.png","datePublished":"2023-11-04T15:49:03+00:00","dateModified":"2023-12-06T06:21:00+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-une-mise-en-forme-conditionnelle-basee-sur-une-date.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-une-mise-en-forme-conditionnelle-basee-sur-une-date.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Terapkan pemformatan bersyarat berdasarkan tanggal"}]},{"@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\/1795","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=1795"}],"version-history":[{"count":0,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1795\/revisions"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1795"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}