{"id":1788,"date":"2023-11-04T19:19:59","date_gmt":"2023-11-04T19:19:59","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/formuller-1\/"},"modified":"2023-12-10T06:00:05","modified_gmt":"2023-12-10T06:00:05","slug":"formuller-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/formuller-1\/","title":{"rendered":"Excel&#39;de 7 ko\u015fullu bi\u00e7imlendirme form\u00fcl\u00fc"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1242007303\"><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>Ko\u015fullu bi\u00e7imlendirmenin en iyi yan\u0131, i\u00e7indeki form\u00fclleri kullanabilmenizdir. Ve form\u00fcllerle \u00e7al\u0131\u015fman\u0131n \u00e7ok basit bir anlam\u0131 var.<\/p><p> Form\u00fcl\u00fcn\u00fcz mant\u0131ksal bir form\u00fcl olmal\u0131 ve sonu\u00e7 DO\u011eRU veya YANLI\u015e olmal\u0131d\u0131r. Form\u00fcl DO\u011eRU de\u011ferini d\u00f6nd\u00fcr\u00fcrse, bi\u00e7imlendirmeyi al\u0131rs\u0131n\u0131z, YANLI\u015e ise hi\u00e7bir \u015fey elde etmezsiniz. Ger\u00e7ek \u015fu ki, form\u00fclleri kullanarak ko\u015fullu bi\u00e7imlendirmeden en iyi \u015fekilde yararlanabilirsiniz.<\/p><p> Evet bu do\u011fru. A\u015fa\u011f\u0131daki \u00f6rnekte h\u00fccredeki de\u011ferin 1000&#8217;den k\u00fc\u00e7\u00fck olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in CF&#8217;de bir form\u00fcl kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-dans-la-mise-en-forme-conditionnelle-pour-verifier-si-la-valeur-est-superieure-1.png\" sizes=\"\" srcset=\"\" alt=\"de\u011ferin daha b\u00fcy\u00fck olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in ko\u015fullu bi\u00e7imlendirmedeki form\u00fclleri kullan\u0131n\"><\/figure><\/div><p> Ve e\u011fer bu de\u011fer 1000&#8217;den k\u00fc\u00e7\u00fckse belirtti\u011fimiz format\u0131 uygulayacakt\u0131r, aksi halde uygulamayacakt\u0131r. Bug\u00fcn bu makalede, bir form\u00fcl kullanarak ko\u015fullu bi\u00e7imlendirmeyi uygulamak i\u00e7in basit ad\u0131mlar\u0131 sizlerle payla\u015fmak istiyorum. Ve g\u00fcnl\u00fck i\u015flerinizde kullanabilece\u011finiz faydal\u0131 \u00f6rneklerden baz\u0131lar\u0131.<\/p><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> Form\u00fcllerle ko\u015fullu bi\u00e7imlendirmeyi uygulama ad\u0131mlar\u0131<\/h2><p> CF&#8217;yi form\u00fcllerle uygulama ad\u0131mlar\u0131 olduk\u00e7a basittir:<\/p><ol><li> Ko\u015fullu bi\u00e7imlendirmenin uygulanaca\u011f\u0131 aral\u0131\u011f\u0131 se\u00e7in.<\/li><li> Bir ko\u015fulun metnine form\u00fcl ekleyin.<\/li><li> Ko\u015ful kar\u015f\u0131land\u0131\u011f\u0131nda uygulanacak format\u0131 belirtin. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-appliquer-une-mise-en-forme-conditionnelle-a-laide-dune-formule-1.png\" sizes=\"\" srcset=\"\" alt=\"form\u00fcl kullanarak ko\u015fullu bi\u00e7imlendirme nas\u0131l uygulan\u0131r\"><\/figure><\/div><p> Bunu do\u011fru bir \u015fekilde \u00f6\u011frenmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mise-en-forme-conditionnelle-avec-fichier-de-donnees-de-formules.xlsx\" rel=\"nofollow\">bu \u00f6rnek dosyay\u0131 buradan indirip<\/a> a\u015fa\u011f\u0131daki detayl\u0131 ad\u0131mlar\u0131 takip etmeyi unutmay\u0131n.<\/p><ul><li> \u00d6ncelikle ko\u015fullu bi\u00e7imlendirmeyi uygulamak istedi\u011finiz aral\u0131\u011f\u0131 se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/pour-appliquer-une-mise-en-forme-conditionnelle-a-laide-de-formules-selectionner-une-plage-1.png\" sizes=\"\" srcset=\"\" alt=\"Form\u00fclleri kullanarak ko\u015fullu bi\u00e7imlendirmeyi uygulamak i\u00e7in bir aral\u0131k se\u00e7in\"><\/figure><\/div><ul><li> Bundan sonra, Ana Sayfa sekmesine gidin \u279c Stiller \u279c Ko\u015fullu Bi\u00e7imlendirme \u279c Yeni Kural \u279c Hangi h\u00fccrenin bi\u00e7imlendirilece\u011fini belirlemek i\u00e7in bir form\u00fcl kullan\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/pour-appliquer-une-mise-en-forme-conditionnelle-a-laide-de-formules-cliquez-sur-nouvelle-regle-1.png\" sizes=\"\" srcset=\"\" alt=\"Form\u00fclleri kullanarak ko\u015fullu bi\u00e7imlendirmeyi uygulamak i\u00e7in Yeni Kural'\u0131 t\u0131klay\u0131n.\"><\/figure><\/div><ul><li> \u015eimdi \u201c <strong><span style=\"color: #000000;\">Form\u00fcl\u00fcn do\u011fru oldu\u011fu de\u011ferleri bi\u00e7imlendir<\/span><\/strong> \u201d k\u0131sm\u0131na a\u015fa\u011f\u0131daki form\u00fcl\u00fc girin.<\/li><\/ul><p> =E5&lt;1000 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/pour-appliquer-une-mise-en-forme-conditionnelle-a-laide-de-formules-entrez-la-formule-1.png\" sizes=\"\" srcset=\"\" alt=\"Form\u00fclleri kullanarak ko\u015fullu bi\u00e7imlendirmeyi uygulamak i\u00e7in bir form\u00fcl girin\"><\/figure><\/div><ul><li> Bir sonraki ad\u0131m uygulanacak format\u0131 belirlemek ve bunun i\u00e7in format butonuna t\u0131klay\u0131p format\u0131 se\u00e7mek. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/pour-appliquer-une-mise-en-forme-conditionnelle-a-laide-de-formules-specifier-la-mise-en-forme-1.png\" sizes=\"\" srcset=\"\" alt=\"form\u00fclleri kullanarak ko\u015fullu bi\u00e7imlendirme uygulamak i\u00e7in bi\u00e7imlendirmeyi belirtin\"><\/figure><\/div><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> CF ileti\u015fim kutusuna bir form\u00fcl girerken sonucunu veya o form\u00fcl\u00fcn ge\u00e7erli olup olmad\u0131\u011f\u0131n\u0131 g\u00f6remezsiniz. Bu nedenle en iyi uygulama, bu form\u00fcl\u00fc CF&#8217;de kullanmadan \u00f6nce bir h\u00fccreye girerek kontrol etmektir.<\/p><h2 id=\"tab-con-3\" class=\"wp-block-heading\"> 1. Ba\u015fka bir h\u00fccreye dayal\u0131 form\u00fcl kullan\u0131n<\/h2><p> Evet, ba\u015fka bir h\u00fccrenin de\u011ferine g\u00f6re ko\u015fullu bi\u00e7imlendirme uygulayabilirsiniz. A\u015fa\u011f\u0131daki \u00f6rne\u011fe bakarsan\u0131z ba\u015fka bir h\u00fccreyi temel alan basit bir form\u00fcl ekledik. Ve e\u011fer ba\u011flant\u0131l\u0131 h\u00fccrenin de\u011feri belirtilen ko\u015fulu kar\u015f\u0131l\u0131yorsa, ko\u015fullu bi\u00e7imlendirme elde edersiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/appliquer-une-mise-en-forme-conditionnelle-avec-une-formule-en-utilisant-une-autre-cellule-2-1.png\" sizes=\"\" srcset=\"\" alt=\"ba\u015fka bir h\u00fccreyi kullanarak bir form\u00fclle ko\u015fullu bi\u00e7imlendirme uygulama\"><\/figure><\/div><p> Ge\u00e7i\u015f %75&#8217;in alt\u0131nda oldu\u011funda k\u0131rm\u0131z\u0131 renkle vurgulanacakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/appliquer-une-mise-en-forme-conditionnelle-avec-une-formule-en-utilisant-une-autre-cellule-avec-un-pourcentage-75-1.png\" sizes=\"\" srcset=\"\" alt=\"y\u00fczde 75'e sahip ba\u015fka bir h\u00fccreyi kullanarak bir form\u00fclle ko\u015fullu bi\u00e7imlendirme uygulama\"><\/figure><\/div><h2 id=\"tab-con-4\" class=\"wp-block-heading\"> 2. IF ile Ko\u015fullu Bi\u00e7imlendirme<\/h2><p> Ko\u015fullar\u0131 d\u00fc\u015f\u00fcnd\u00fc\u011f\u00fcmde akl\u0131ma ilk gelen \u015fey IF fonksiyonunu kullanmakt\u0131r. Ve bu i\u015flevin en iyi yan\u0131, ko\u015fullu bi\u00e7imlendirmeye m\u00fckemmel \u015fekilde uymas\u0131d\u0131r. Size bir \u00f6rnek g\u00f6stereyim: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-pour-appliquer-une-mise-en-forme-conditionnelle-avec-if-1.png\" sizes=\"\" srcset=\"\" alt=\"if ile ko\u015fullu bi\u00e7imlendirmeyi uygulamak i\u00e7in form\u00fclleri kullan\u0131n\"><\/figure><\/div><p> Burada bir ko\u015ful olu\u015fturmak i\u00e7in IF&#8217;yi kulland\u0131k ve ko\u015ful, B3:B9 aral\u0131\u011f\u0131ndaki &#8220;Tamamland\u0131&#8221; say\u0131s\u0131 A3:A9 aral\u0131\u011f\u0131ndaki g\u00f6rev say\u0131s\u0131na e\u015fit oldu\u011funda, son durum g\u00f6r\u00fcnecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cette-formule-en-formatage-conditionnel-formatera-la-cellule-lorsque-toutes-les-taches-seront-terminees-1.gif\" sizes=\"\" srcset=\"\" alt=\"ko\u015fullu bi\u00e7imlendirmedeki bu form\u00fcl, t\u00fcm g\u00f6revler tamamland\u0131\u011f\u0131nda h\u00fccreyi bi\u00e7imlendirecektir\"><\/figure><\/div><h2 id=\"tab-con-5\" class=\"wp-block-heading\"> 3. \u00c7oklu Ko\u015fullarla Ko\u015fullu Bi\u00e7imlendirme<\/h2><p> Formata uygulamak i\u00e7in birden fazla kontrol ko\u015fulu olu\u015fturabilirsiniz. Ko\u015fullar\u0131n t\u00fcm\u00fc veya herhangi biri kar\u015f\u0131land\u0131\u011f\u0131nda h\u00fccreye ko\u015fullu bi\u00e7imlendirme uygulanacakt\u0131r. \u015eehrimin ortalama s\u0131cakl\u0131\u011f\u0131n\u0131 kulland\u0131\u011f\u0131m\u0131z a\u015fa\u011f\u0131daki \u00f6rne\u011fe bak\u0131n.<\/p><p> S\u0131cakl\u0131\u011f\u0131n olduk\u00e7a uygun oldu\u011fu aylar\u0131 vurgulamak i\u00e7in basit bir \u015fekilde birle\u015ftirilmi\u015f SI-AND kulland\u0131k. S\u0131cakl\u0131\u011f\u0131n 15 ila 35 santigrat derece aras\u0131nda oldu\u011fu aylar renkli ge\u00e7ecek. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-si-et-formule-dans-la-mise-en-forme-conditionnelle-pour-mettre-en-surbrillance-la-cellule-avec-des-tempratures-1.gif\" sizes=\"\" srcset=\"\" alt=\"S\u0131cakl\u0131k i\u00e7eren h\u00fccreyi vurgulamak i\u00e7in ko\u015fullu bi\u00e7imlendirmede if ve form\u00fcl\u00fc kullan\u0131n\"><\/figure><\/div><p> Benzer \u015fekilde <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/eger-veya-1\/\">if with veya function \u00f6\u011fesini<\/a> de kullanabilirsiniz.<\/p><h2 id=\"tab-con-6\" class=\"wp-block-heading\"> 4. Ko\u015fullu bi\u00e7imlendirmeyle alternatif sat\u0131rlar\u0131 vurgulay\u0131n<\/h2><p> Her alternatif sat\u0131r\u0131 vurgulamak i\u00e7in a\u015fa\u011f\u0131daki nCF form\u00fcl\u00fcn\u00fc kullanabilirsiniz.<\/p><p class=\"formula\"> =INT(MOD(SATIR();2))<\/p><p> Bu form\u00fcl\u00fc kullanarak tek say\u0131 i\u00e7eren her sat\u0131r vurgulanacakt\u0131r. E\u011fer tam tersini yapmak istiyorsan\u0131z a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-avec-des-lignes-alternatives-en-surbrillance-utilisant-une-formule-dans-une-mise-en-forme-conditionnelle-1.png\" sizes=\"\" srcset=\"\" alt=\"ko\u015fullu bi\u00e7imlendirmede bir form\u00fcl kullanan vurgulanm\u0131\u015f alternatif sat\u0131rlar\u0131n bulundu\u011fu tablo\"><\/figure><\/div><p class=\"formula\"> =INT(MOD(SATIR()+1,2))<\/p><p> Ayn\u0131 t\u00fcr form\u00fcl s\u00fctunlar (tek ve \u00e7ift) i\u00e7in de kullan\u0131labilir.<\/p><p class=\"formula\"> =INT(MOD(S\u00dcTUN();2))<\/p><p> Ve e\u015fit s\u00fctunlar i\u00e7in.<\/p><p class=\"formula\"> =INT(MOD(S\u00dcTUN()+1,2)) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-la-mise-en-forme-conditionnelle-mettre-en-surbrillance-la-colonne-alternative-1.gif\" sizes=\"\" srcset=\"\" alt=\"ko\u015fullu bi\u00e7imlendirmeyi kullan alternatif s\u00fctunu vurgula\"><\/figure><\/div><h2 id=\"tab-con-7\" class=\"wp-block-heading\"> 5. CF kullanarak hatal\u0131 h\u00fccreleri vurgulay\u0131n<\/h2><p> \u015eimdi bir h\u00fccrenin hata i\u00e7erip i\u00e7ermedi\u011fini kontrol edece\u011fimiz ba\u015fka bir \u00f6rne\u011fe gelelim. Yapmam\u0131z gereken, ko\u015fulu kontrol edip sonucu DO\u011eRU veya YANLI\u015e olarak d\u00f6nd\u00fcrebilecek bir form\u00fcl\u00fc ko\u015fullu bi\u00e7imlendirmeye eklemektir. H\u00fccrelerde say\u0131lar, metinler veya baz\u0131 belirli de\u011ferler olup olmad\u0131\u011f\u0131n\u0131 bile kontrol edebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mettre-en-evidence-les-erreurs-des-cellules-a-laide-de-la-mise-en-forme-conditionnelle-1.png\" sizes=\"\" srcset=\"\" alt=\"ko\u015fullu bi\u00e7imlendirmeyi kullanarak h\u00fccre hatalar\u0131n\u0131 vurgulay\u0131n\"><\/figure><\/div><h2 id=\"tab-con-8\" class=\"wp-block-heading\"> 6. Ko\u015fullu Bi\u00e7imlendirme ile Kontrol Listesi Olu\u015fturun<\/h2><p> \u015eimdi zekaya biraz yarat\u0131c\u0131l\u0131k katal\u0131m. Ba\u015fka bir h\u00fccreye dayal\u0131 form\u00fcl\u00fcn nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 zaten \u00f6\u011frendiniz. Burada <a href=\"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/\">bir onay kutusunu B1 h\u00fccresine ba\u011flad\u0131k<\/a> ve ayr\u0131ca B1&#8217;i A1 h\u00fccresi i\u00e7in ko\u015fullu bi\u00e7imlendirmede kullan\u0131lan form\u00fcle ba\u011flad\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/liste-de-controle-utilisant-la-mise-en-forme-conditionnelle-et-la-case-a-cocher-1.png\" sizes=\"\" srcset=\"\" alt=\"ko\u015fullu bi\u00e7imlendirme ve onay kutusunu kullanan kontrol listesi\"><\/figure><\/div><p> \u015eimdi <a href=\"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/\">kutuyu<\/a> i\u015faretlerseniz, B1 h\u00fccresinin de\u011feri TRUE olacak ve A1 h\u00fccresi ko\u015fullu bi\u00e7imlendirmesini [ <a href=\"https:\/\/exceladvisor.org\/tr\/kamis\/\">\u00fcst\u00fc \u00e7izili<\/a> ] alacakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-liste-de-controle-dynamique-utilisant-des-formules-en-format-conditionnel-1.gif\" sizes=\"\" srcset=\"\" alt=\"ko\u015fullu formattaki form\u00fclleri kullanan dinamik bir kontrol listesi\"><\/figure><\/div><h2 id=\"tab-con-9\" class=\"wp-block-heading\"> Paket servis<\/h2><ol><li> Form\u00fcl\u00fcn\u00fcz DO\u011eRU veya YANLI\u015e sonucuna yol a\u00e7acak mant\u0131ksal bir form\u00fcl olmal\u0131d\u0131r.<\/li><li> Verilerinizi ko\u015fullu bi\u00e7imlendirmeyle a\u015f\u0131r\u0131 y\u00fcklememeye \u00e7al\u0131\u015f\u0131n.<\/li><li> Her zaman <a href=\"https:\/\/www.deskbright.com\/excel\/absolute-and-relative-cell-references\/\" target=\"_blank\" rel=\"noreferrer noopener\">g\u00f6receli ve mutlak referanslar\u0131<\/a> ger\u00e7ek anlamda kullan\u0131n.<\/li><\/ol><h2 id=\"tab-con-10\" class=\"wp-block-heading\"> \u00d6rnek dosya<\/h2><p> Daha fazla bilgi edinmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formules-dans-la-mise-en-forme-conditionnelle-2.xlsx\" rel=\"nofollow\">bu \u00f6rnek dosyay\u0131 buradan indirin<\/a> .<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/excel-ilerlemesi\/\">\u0130leri D\u00fczey Excel Dersleri<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/otomatik-format\/\">Excel&#8217;de otomatik bi\u00e7imlendirme se\u00e7ene\u011fi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/alternatif-cizgileri-vurgula\/\">Renk \u00f6rne\u011fiyle Excel&#8217;deki alternatif sat\u0131rlar\u0131 vurgulay\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/simge-oyunlari\/\" data-wpil=\"url\">Excel&#8217;de simge k\u00fcmelerini kullanma (ko\u015fullu bi\u00e7imlendirme)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-1788","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>Excel&#039;de 7 Ko\u015fullu Bi\u00e7imlendirme Form\u00fcl\u00fc (2023)<\/title>\n<meta name=\"description\" content=\"Kural #1: Ko\u015fullu bi\u00e7imlendirmede form\u00fcl\u00fcn\u00fcz mant\u0131ksal bir form\u00fcl olmal\u0131 ve sonu\u00e7 DO\u011eRU veya YANLI\u015e olmal\u0131d\u0131r. \u0130\u00e7inde\" \/>\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\/tr\/formuller-1\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de 7 Ko\u015fullu Bi\u00e7imlendirme Form\u00fcl\u00fc (2023)\" \/>\n<meta property=\"og:description\" content=\"Kural #1: Ko\u015fullu bi\u00e7imlendirmede form\u00fcl\u00fcn\u00fcz mant\u0131ksal bir form\u00fcl olmal\u0131 ve sonu\u00e7 DO\u011eRU veya YANLI\u015e olmal\u0131d\u0131r. \u0130\u00e7inde\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/formuller-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:00:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-dans-la-mise-en-forme-conditionnelle-pour-verifier-si-la-valeur-est-superieure-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/formuller-1\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/formuller-1\/\",\"name\":\"Excel&#39;de 7 Ko\u015fullu Bi\u00e7imlendirme Form\u00fcl\u00fc (2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/formuller-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/formuller-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-dans-la-mise-en-forme-conditionnelle-pour-verifier-si-la-valeur-est-superieure-1.png\",\"datePublished\":\"2023-11-04T19:19:59+00:00\",\"dateModified\":\"2023-12-10T06:00:05+00:00\",\"description\":\"Kural #1: Ko\u015fullu bi\u00e7imlendirmede form\u00fcl\u00fcn\u00fcz mant\u0131ksal bir form\u00fcl olmal\u0131 ve sonu\u00e7 DO\u011eRU veya YANLI\u015e olmal\u0131d\u0131r. \u0130\u00e7inde\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/formuller-1\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/formuller-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/formuller-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-dans-la-mise-en-forme-conditionnelle-pour-verifier-si-la-valeur-est-superieure-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-dans-la-mise-en-forme-conditionnelle-pour-verifier-si-la-valeur-est-superieure-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/formuller-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de 7 ko\u015fullu bi\u00e7imlendirme form\u00fcl\u00fc\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de 7 Ko\u015fullu Bi\u00e7imlendirme Form\u00fcl\u00fc (2023)","description":"Kural #1: Ko\u015fullu bi\u00e7imlendirmede form\u00fcl\u00fcn\u00fcz mant\u0131ksal bir form\u00fcl olmal\u0131 ve sonu\u00e7 DO\u011eRU veya YANLI\u015e olmal\u0131d\u0131r. \u0130\u00e7inde","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\/tr\/formuller-1\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de 7 Ko\u015fullu Bi\u00e7imlendirme Form\u00fcl\u00fc (2023)","og_description":"Kural #1: Ko\u015fullu bi\u00e7imlendirmede form\u00fcl\u00fcn\u00fcz mant\u0131ksal bir form\u00fcl olmal\u0131 ve sonu\u00e7 DO\u011eRU veya YANLI\u015e olmal\u0131d\u0131r. \u0130\u00e7inde","og_url":"https:\/\/exceladvisor.org\/tr\/formuller-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:00:05+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-dans-la-mise-en-forme-conditionnelle-pour-verifier-si-la-valeur-est-superieure-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"5 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/formuller-1\/","url":"https:\/\/exceladvisor.org\/tr\/formuller-1\/","name":"Excel&#39;de 7 Ko\u015fullu Bi\u00e7imlendirme Form\u00fcl\u00fc (2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/formuller-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/formuller-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-dans-la-mise-en-forme-conditionnelle-pour-verifier-si-la-valeur-est-superieure-1.png","datePublished":"2023-11-04T19:19:59+00:00","dateModified":"2023-12-10T06:00:05+00:00","description":"Kural #1: Ko\u015fullu bi\u00e7imlendirmede form\u00fcl\u00fcn\u00fcz mant\u0131ksal bir form\u00fcl olmal\u0131 ve sonu\u00e7 DO\u011eRU veya YANLI\u015e olmal\u0131d\u0131r. \u0130\u00e7inde","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/formuller-1\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/formuller-1\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/formuller-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-dans-la-mise-en-forme-conditionnelle-pour-verifier-si-la-valeur-est-superieure-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-dans-la-mise-en-forme-conditionnelle-pour-verifier-si-la-valeur-est-superieure-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/formuller-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de 7 ko\u015fullu bi\u00e7imlendirme form\u00fcl\u00fc"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1788","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1788"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1788\/revisions"}],"predecessor-version":[{"id":2377,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1788\/revisions\/2377"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}