{"id":5100,"date":"2023-07-03T16:56:10","date_gmt":"2023-07-03T16:56:10","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-kosullu-bicimlendirme-tarihleri-bir-yildan-fazla\/"},"modified":"2023-07-03T16:56:10","modified_gmt":"2023-07-03T16:56:10","slug":"excel-kosullu-bicimlendirme-tarihleri-bir-yildan-fazla","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-kosullu-bicimlendirme-tarihleri-bir-yildan-fazla\/","title":{"rendered":"Excel: bir y\u0131ldan eski tarihlere ko\u015fullu bi\u00e7imlendirme uygulay\u0131n"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Tarihi Excel&#8217;deki ge\u00e7erli tarihten bir y\u0131ldan daha eski olan h\u00fccrelere ko\u015fullu bi\u00e7imlendirme uygulamak i\u00e7in <strong>Giri\u015f<\/strong> sekmesindeki <strong>Ko\u015fullu Bi\u00e7imlendirme<\/strong> a\u00e7\u0131l\u0131r men\u00fcs\u00fcndeki <strong>Yeni Kural<\/strong> se\u00e7ene\u011fini kullanabilirsiniz.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30972 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/base1.jpg\" alt=\"\" width=\"602\" height=\"513\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki \u00f6rnek, bu se\u00e7ene\u011fin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>\u00d6rnek: Bir y\u0131ldan eski tarihlere ko\u015fullu bi\u00e7imlendirme uygulama<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Diyelim ki Excel&#8217;de \u00e7e\u015fitli ki\u015filerin yak\u0131n zamanda bir spor salonunu ne zaman ziyaret etti\u011fini g\u00f6steren a\u015fa\u011f\u0131daki veri k\u00fcmesine sahibiz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39727 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sur-un-an2.png\" alt=\"\" width=\"470\" height=\"395\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu yaz\u0131 <strong>18.08.2023<\/strong> tarihinde yaz\u0131lmaktad\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bir y\u0131ldan daha eski herhangi bir tarihe ko\u015fullu bi\u00e7imlendirme uygulamak istedi\u011fimizi varsayal\u0131m.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bunu yapmak i\u00e7in <strong>B2:B13<\/strong> aral\u0131\u011f\u0131ndaki h\u00fccreleri vurgulayabilir, ard\u0131ndan <strong>Giri\u015f<\/strong> sekmesinde <strong>Ko\u015fullu Bi\u00e7imlendirme<\/strong> a\u00e7\u0131l\u0131r men\u00fcs\u00fcne t\u0131klay\u0131p ard\u0131ndan <strong>Yeni Kural&#8217;a<\/strong> t\u0131klayabiliriz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30972 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/base1.jpg\" alt=\"\" width=\"602\" height=\"513\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">G\u00f6r\u00fcnt\u00fclenen yeni pencerede, <strong>Hangi h\u00fccrelerin bi\u00e7imlendirilece\u011fini belirlemek i\u00e7in form\u00fcl kullan&#8217;\u0131<\/strong> t\u0131klay\u0131n, ard\u0131ndan kutuya <strong>=B2&lt;TODAY()-365<\/strong> yaz\u0131n, ard\u0131ndan <strong>Bi\u00e7im<\/strong> d\u00fc\u011fmesini t\u0131klay\u0131n ve kullan\u0131lacak dolgu rengini se\u00e7in.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39728\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sur-un-an3.png\" alt=\"Excel ko\u015fullu bi\u00e7imlendirme tarihlerinin bir y\u0131ldan eski olmas\u0131\" width=\"676\" height=\"429\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><strong>OK<\/strong> tu\u015funa bast\u0131\u011f\u0131m\u0131zda, <strong>B2:B13<\/strong> aral\u0131\u011f\u0131nda bug\u00fcnden (18\/08\/2023) bir y\u0131ldan daha eski bir tarihe sahip olan t\u00fcm h\u00fccreler vurgulanacakt\u0131r:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39729 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sur-un-an4.png\" alt=\"\" width=\"479\" height=\"389\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bug\u00fcnden farkl\u0131 y\u0131l say\u0131s\u0131na sahip tarihlere ko\u015fullu bi\u00e7imlendirme uygulamak istiyorsan\u0131z form\u00fcldeki son de\u011feri bu say\u0131yla \u00e7arpman\u0131z yeterlidir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u00d6rne\u011fin, tarihi bug\u00fcnden <strong>2 y\u0131ldan<\/strong> daha eski olan h\u00fccreleri vurgulamak i\u00e7in ko\u015fullu bi\u00e7imlendirme kural\u0131 kutusuna <strong>=B2&lt;TODAY()-365*2<\/strong> yazabilirsiniz.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Not<\/strong> : Biz bu \u00f6rnekte ko\u015fullu bi\u00e7imlendirme i\u00e7in a\u00e7\u0131k ye\u015fil dolgu kullanmay\u0131 se\u00e7iyoruz ancak siz ko\u015fullu bi\u00e7imlendirme i\u00e7in istedi\u011finiz rengi ve stili se\u00e7ebilirsiniz.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Ek kaynaklar<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde Excel&#8217;deki di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/tr\/excel-kosullu-bicimlendirme-gec-tarihler\/\" target=\"_blank\" rel=\"noopener\">Excel: Gecikmi\u015f tarihlere ko\u015fullu bi\u00e7imlendirme uygulay\u0131n<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excelde-iki-tarih-arasinda-kosullu-bicimlendirme\/\" target=\"_blank\" rel=\"noopener\">Excel: h\u00fccre iki tarih aras\u0131ndaysa ko\u015fullu bi\u00e7imlendirme uygulay\u0131n<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-kosullu-bicimlendirme-birden-cok-kosul\/\" target=\"_blank\" rel=\"noopener\">Excel: Birden \u00e7ok ko\u015fula dayal\u0131 ko\u015fullu bi\u00e7imlendirme uygulay\u0131n<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tarihi Excel&#8217;deki ge\u00e7erli tarihten bir y\u0131ldan daha eski olan h\u00fccrelere ko\u015fullu bi\u00e7imlendirme uygulamak i\u00e7in Giri\u015f sekmesindeki Ko\u015fullu Bi\u00e7imlendirme a\u00e7\u0131l\u0131r men\u00fcs\u00fcndeki Yeni Kural se\u00e7ene\u011fini kullanabilirsiniz. A\u015fa\u011f\u0131daki \u00f6rnek, bu se\u00e7ene\u011fin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir. \u00d6rnek: Bir y\u0131ldan eski tarihlere ko\u015fullu bi\u00e7imlendirme uygulama Diyelim ki Excel&#8217;de \u00e7e\u015fitli ki\u015filerin yak\u0131n zamanda bir spor salonunu ne zaman ziyaret etti\u011fini g\u00f6steren [&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":[],"class_list":["post-5100","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel: Bir Y\u0131ldan Eski Tarihlere Ko\u015fullu Bi\u00e7imlendirme Uygulay\u0131n - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, Excel&#039;de bir y\u0131ldan daha eski tarihlere ko\u015fullu bi\u00e7imlendirmenin nas\u0131l uygulanaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\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\/tr\/excel-kosullu-bicimlendirme-tarihleri-bir-yildan-fazla\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Bir Y\u0131ldan Eski Tarihlere Ko\u015fullu Bi\u00e7imlendirme Uygulay\u0131n - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, Excel&#039;de bir y\u0131ldan daha eski tarihlere ko\u015fullu bi\u00e7imlendirmenin nas\u0131l uygulanaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excel-kosullu-bicimlendirme-tarihleri-bir-yildan-fazla\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-03T16:56:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/base1.jpg\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-kosullu-bicimlendirme-tarihleri-bir-yildan-fazla\/\",\"url\":\"https:\/\/statorials.org\/tr\/excel-kosullu-bicimlendirme-tarihleri-bir-yildan-fazla\/\",\"name\":\"Excel: Bir Y\u0131ldan Eski Tarihlere Ko\u015fullu Bi\u00e7imlendirme Uygulay\u0131n - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-03T16:56:10+00:00\",\"dateModified\":\"2023-07-03T16:56:10+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, Excel&#39;de bir y\u0131ldan daha eski tarihlere ko\u015fullu bi\u00e7imlendirmenin nas\u0131l uygulanaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excel-kosullu-bicimlendirme-tarihleri-bir-yildan-fazla\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excel-kosullu-bicimlendirme-tarihleri-bir-yildan-fazla\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-kosullu-bicimlendirme-tarihleri-bir-yildan-fazla\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: bir y\u0131ldan eski tarihlere ko\u015fullu bi\u00e7imlendirme uygulay\u0131n\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel: Bir Y\u0131ldan Eski Tarihlere Ko\u015fullu Bi\u00e7imlendirme Uygulay\u0131n - Statorials","description":"Bu e\u011fitimde, Excel&#39;de bir y\u0131ldan daha eski tarihlere ko\u015fullu bi\u00e7imlendirmenin nas\u0131l uygulanaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","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\/tr\/excel-kosullu-bicimlendirme-tarihleri-bir-yildan-fazla\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel: Bir Y\u0131ldan Eski Tarihlere Ko\u015fullu Bi\u00e7imlendirme Uygulay\u0131n - Statorials","og_description":"Bu e\u011fitimde, Excel&#39;de bir y\u0131ldan daha eski tarihlere ko\u015fullu bi\u00e7imlendirmenin nas\u0131l uygulanaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excel-kosullu-bicimlendirme-tarihleri-bir-yildan-fazla\/","og_site_name":"Statorials","article_published_time":"2023-07-03T16:56:10+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/base1.jpg"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/excel-kosullu-bicimlendirme-tarihleri-bir-yildan-fazla\/","url":"https:\/\/statorials.org\/tr\/excel-kosullu-bicimlendirme-tarihleri-bir-yildan-fazla\/","name":"Excel: Bir Y\u0131ldan Eski Tarihlere Ko\u015fullu Bi\u00e7imlendirme Uygulay\u0131n - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-03T16:56:10+00:00","dateModified":"2023-07-03T16:56:10+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, Excel&#39;de bir y\u0131ldan daha eski tarihlere ko\u015fullu bi\u00e7imlendirmenin nas\u0131l uygulanaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excel-kosullu-bicimlendirme-tarihleri-bir-yildan-fazla\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excel-kosullu-bicimlendirme-tarihleri-bir-yildan-fazla\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excel-kosullu-bicimlendirme-tarihleri-bir-yildan-fazla\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel: bir y\u0131ldan eski tarihlere ko\u015fullu bi\u00e7imlendirme uygulay\u0131n"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/5100","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=5100"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/5100\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=5100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=5100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=5100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}