{"id":1658,"date":"2023-11-13T00:34:06","date_gmt":"2023-11-13T00:34:06","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/"},"modified":"2023-12-10T06:01:32","modified_gmt":"2023-12-10T06:01:32","slug":"kosullu-bicimlendirme","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/","title":{"rendered":"Excel&#39;de ko\u015fullu bi\u00e7imlendirme: tam k\u0131lavuz"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-559813009\"><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>Bu e\u011fitimde ko\u015fullu bi\u00e7imlendirmenin kullan\u0131m\u0131na ve mevcut se\u00e7eneklere ili\u015fkin kapsaml\u0131 bir g\u00f6r\u00fcn\u00fcm sunulmaktad\u0131r. Ayr\u0131ca verilerle \u00e7al\u0131\u015f\u0131rken ger\u00e7ek d\u00fcnyada kullanmay\u0131 \u00f6\u011frenebilece\u011finiz \u00f6rneklerin bir listesini de verir.<\/p><h2 id=\"h-what-is-conditional-formatting\" class=\"wp-block-heading\"> Ko\u015fullu bi\u00e7imlendirme nedir?<\/h2><p> Ko\u015fullu bi\u00e7imlendirme, ko\u015fullu bir h\u00fccreye veya aral\u0131\u011fa uygulama se\u00e7ene\u011fidir. Bunu kulland\u0131\u011f\u0131n\u0131zda, \u00f6nce bir ko\u015fulu test eder ve e\u011fer bu ko\u015ful DO\u011eRU ise ancak o zaman bi\u00e7imlendirmeyi uygular. \u00d6rne\u011fin, bir aral\u0131ktaki hatal\u0131 h\u00fccreler veya t\u00fcm bo\u015f h\u00fccreler i\u00e7in k\u0131rm\u0131z\u0131y\u0131 kullanmak istiyorsunuz.<\/p><p> Ko\u015fullu bi\u00e7imlendirmeyi iki \u015fekilde kullanabilirsiniz:<\/p><ul><li> \u00d6nceden tan\u0131mlanm\u0131\u015f kurallar<\/li><li> Form\u00fcll\u00fc \u00f6zel kural<\/li><\/ul><p> Bu derste her ikisini de ke\u015ffedece\u011fiz.<\/p><h2 id=\"h-simple-example-to-understand-conditional-formatting\" class=\"wp-block-heading\"> Ko\u015fullu bi\u00e7imlendirmeyi anlamak i\u00e7in basit bir \u00f6rnek<\/h2><p> Ko\u015fullu bi\u00e7imlendirmeyi anlamak i\u00e7in bir \u00f6rnek verelim. A\u015fa\u011f\u0131daki \u00f6rnekte, burada ad verileriniz var ve ad\u0131nda &#8220;Aryan&#8221; bulunan h\u00fccreleri vurgulaman\u0131z gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90775\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comprendre-la-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"1-ko\u015fullu-bi\u00e7imlendirmeyi anlay\u0131n\" width=\"554\" height=\"292\"><\/figure><\/div><ol><li> Bunu yapmak i\u00e7in Ana Sayfa &gt; Ko\u015fullu Bi\u00e7imlendirme &gt; H\u00fccre Vurgulama Kural\u0131 &gt; \u0130\u00e7eren Metin&#8217;e gidin. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-ko\u015fullu-bi\u00e7imlendirme i\u00e7eren metin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-texte-contenant-une-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"2-text-that-contains-conditional-formatting\" width=\"457\" height=\"433\"><\/li><li> Se\u00e7eneklere t\u0131klad\u0131\u011f\u0131n\u0131zda, \u201cAryan\u201d metnini girebilece\u011finiz ve ard\u0131ndan ilgili h\u00fccreye uygulamak istedi\u011finiz rengi ayarlayabilece\u011finiz bir ileti\u015fim kutusu g\u00f6r\u00fcnecektir. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-size-ko\u015fullu-bi\u00e7imlendirme-ileti\u015fim kutusunu g\u00f6sterece\u011fim\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-vous-montre-une-boite-de-dialogue-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"3-show-you-a-dialog-box-conditional-formatting\" width=\"394\" height=\"397\"><\/li><li> \u201cAryan\u201d metninin bulundu\u011fu h\u00fccreyi an\u0131nda vurgulayacakt\u0131r. Ve bundan sonra Tamam&#8217;a t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-h\u00fccreyi-ko\u015fullu-bi\u00e7imlendirmeyi an\u0131nda vurgulama\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-mettre-en-surbrillance-instantanement-la-mise-en-forme-conditionnelle-de-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"4-instantly-highlight-the-cell-conditional-formatting\" width=\"450\" height=\"237\"><\/li><\/ol><p> \u015eunu anlayal\u0131m: Burada &#8220;Aryan&#8221; metnini i\u00e7eren h\u00fccreler i\u00e7in bir durum testimiz var. Ve yaln\u0131zca bu metnin bulundu\u011fu h\u00fccreler vurgulan\u0131r.<\/p><p class=\"qt-tip\"> <strong>Not:<\/strong> Ko\u015fullu bi\u00e7imlendirme, Excel&#8217;deki ger\u00e7ek zamanl\u0131 verileri h\u0131zla analiz etmenize yard\u0131mc\u0131 olacak en kullan\u0131\u015fl\u0131 ara\u00e7lardan biridir.<\/p><h2 id=\"h-available-pre-defined-conditional-formatting-rules\" class=\"wp-block-heading\"> \u00d6nceden tan\u0131mlanm\u0131\u015f ko\u015fullu bi\u00e7imlendirme kurallar\u0131 mevcuttur<\/h2><p> Be\u015f ana se\u00e7enek, ko\u015fullu bi\u00e7imlendirmede kullanabilece\u011finiz \u00f6nceden tan\u0131mlanm\u0131\u015f kurallara sahiptir. \u00d6nceden tan\u0131mlanm\u0131\u015f se\u00e7eneklerle birlikte uygulanacak \u00f6nceden tan\u0131mlanm\u0131\u015f bi\u00e7imlendirme de gelir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90822\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-regles-predefinies-de-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"5-\u00f6nceden tan\u0131mlanm\u0131\u015f-kurallar-ko\u015fullu-bi\u00e7imlendirme\" width=\"247\" height=\"373\"><\/figure><\/div><h3 id=\"h-1-highlight-cells-rule\" class=\"wp-block-heading\"> 1. H\u00fccre cetvelini vurgulay\u0131n<\/h3><p> H\u00fccre vurgulama kural\u0131 ile h\u00fccrelere de\u011ferlerini kontrol ederek ko\u015fullu bi\u00e7imlendirme uygulayabilirsiniz. Say\u0131s\u0131 1500&#8217;den k\u00fc\u00e7\u00fck olan bir h\u00fccreyi vurgulamak istiyorsan\u0131z listedeki k\u00fc\u00e7\u00fckt\u00fcr se\u00e7ene\u011fini kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90824\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-cellules-ou-un-nombre-est-inferieur-a-la-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"Bir say\u0131n\u0131n ko\u015fullu bi\u00e7imlendirmeden k\u00fc\u00e7\u00fck oldu\u011fu 6 h\u00fccreli bi\u00e7imlendirme\" width=\"219\" height=\"410\"><\/figure><\/div><p> Burada metin, tarih ve say\u0131lar gibi t\u00fcm veri t\u00fcrlerini i\u015fleme se\u00e7enekleriniz vard\u0131r.<\/p><h3 id=\"h-2-top-bottom-rules\" class=\"wp-block-heading\"> 2. \u00dcst\/alt kurallar\u0131<\/h3><p> Yukar\u0131 ve A\u015fa\u011f\u0131 se\u00e7enekleri ile verilerinizi h\u0131zl\u0131 bir \u015fekilde analiz edebilirsiniz. \u0130lk 10 veya alt 10 de\u011feri ve ortalaman\u0131n alt\u0131ndaki veya \u00fcst\u00fcndeki de\u011ferleri vurgulama se\u00e7enekleri vard\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90825\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-mise-en-forme-conditionnelle-en-haut-et-en-bas.png\" sizes=\"auto, \" srcset=\"\" alt=\"7 y\u00fcksek ve d\u00fc\u015f\u00fck de\u011ferle ko\u015fullu bi\u00e7imlendirme\" width=\"213\" height=\"365\"><\/figure><\/div><p> Hatta bu se\u00e7enekleri ihtiya\u00e7lar\u0131n\u0131za g\u00f6re \u00f6zelle\u015ftirebilirsiniz; diyelim ki 10 yerine ilk 20 de\u011feri vurgulamak istiyorsan\u0131z bunu yapabilirsiniz.<\/p><h3 id=\"h-3-data-bars\" class=\"wp-block-heading\"> 3. Veri \u00c7ubuklar\u0131<\/h3><p> Veri \u00e7ubuklar\u0131, se\u00e7ilen h\u00fccrelerin de\u011ferlerine dayal\u0131 bir veri \u00e7ubu\u011fu olu\u015fturman\u0131za yard\u0131mc\u0131 olabilecek, h\u00fccrelerdeki k\u00fc\u00e7\u00fck grafiklerdir. En y\u00fcksek ve en d\u00fc\u015f\u00fck de\u011feri dikkate al\u0131r ve se\u00e7ilen t\u00fcm h\u00fccrelere bunlar\u0131 temel alan veri \u00e7ubuklar\u0131 ekler. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90826\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Mise-en-forme-conditionnelle-de-8-barres-de-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"8-veri \u00e7ubuklar\u0131-ko\u015fullu-bi\u00e7imlendirme\" width=\"455\" height=\"372\"><\/figure><\/div><p class=\"qt-tip\"> <strong>\u0130pucu:<\/strong> S\u00fctun geni\u015fli\u011fini de\u011fi\u015ftirdi\u011finizde veri \u00e7ubu\u011fu geni\u015fli\u011fini buna g\u00f6re ayarlar.<\/p><h3 id=\"h-4-color-scales\" class=\"wp-block-heading\"> 4. Renk skalalar\u0131<\/h3><p> Renk \u00f6l\u00e7ekleri, aral\u0131ktaki de\u011ferlerinize g\u00f6re h\u00fccreleri vurgulaman\u0131za yard\u0131mc\u0131 olur. Kullanabilece\u011finiz iki veya \u00fc\u00e7 renk skalas\u0131 vard\u0131r. Kullanabilece\u011finiz 12 \u00f6nceden tan\u0131mlanm\u0131\u015f renk skalas\u0131 vard\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90827\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Mise-en-forme-conditionnelle-de-9-echelles-de-couleurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"9 renk skalas\u0131yla ko\u015fullu bi\u00e7imlendirme\" width=\"459\" height=\"289\"><\/figure><\/div><p> Bu renk \u00f6l\u00e7ekleri, verileri an\u0131nda h\u0131zl\u0131 bir \u015fekilde tan\u0131mlaman\u0131za yard\u0131mc\u0131 olur.<\/p><h3 id=\"h-5-icon-sets\" class=\"wp-block-heading\"> 5. Simge setleri<\/h3><p> Simge k\u00fcmeleriyle, aral\u0131ktaki de\u011ferlere g\u00f6re simgeyi bir h\u00fccreye uygulayabilirsiniz. \u00d6rne\u011fin, bir de\u011fer aral\u0131kta daha y\u00fcksekse bir yukar\u0131 ok g\u00f6r\u00fcnt\u00fclenir; daha d\u00fc\u015f\u00fckse, a\u015fa\u011f\u0131 ok olacakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90828\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-jeux-dicones-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"10 ko\u015fullu bi\u00e7imlendirme simge seti\" width=\"461\" height=\"433\"><\/figure><\/div><p> G\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi kullanabilece\u011finiz birka\u00e7 simge setiniz var.<\/p><p class=\"qt-tip\"> <strong>Not:<\/strong> Bu \u00f6nceden tan\u0131mlanm\u0131\u015f kurallar, durumlar\u0131n %80&#8217;inden fazlas\u0131nda faydal\u0131 olacakt\u0131r. Daha da ileri gitmek istiyorsan\u0131z \u00f6zel bir kural olu\u015fturabilirsiniz.<\/p><h2 id=\"h-create-a-custom-new-rule\" class=\"wp-block-heading\"> Yeni bir \u00f6zel kural olu\u015fturun<\/h2><p> Ayr\u0131ca isterseniz \u00f6zel kurallar da olu\u015fturabilirsiniz. &#8220;Yeni Kural&#8221;\u0131 t\u0131klad\u0131\u011f\u0131n\u0131zda, ko\u015fullu bi\u00e7imlendirmeyi uygulamak i\u00e7in \u00f6zel bir kural olu\u015fturmay\u0131 se\u00e7ebilece\u011finiz bir ileti\u015fim kutusu a\u00e7\u0131l\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90829\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-creer-une-regle-personnalisee-pour-appliquer-une-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"11-ko\u015fullu-bi\u00e7imlendirmeyi-uygulamak i\u00e7in-\u00f6zel-bir-kural olu\u015fturun\" width=\"585\" height=\"468\"><\/figure><\/div><p> Bu ileti\u015fim kutusunda yukar\u0131da bahsetti\u011fimiz t\u00fcm se\u00e7enekleri se\u00e7ip \u00f6zel bir \u015fekilde uygulayabilirsiniz. Ve bu ileti\u015fim kutusunda, \u00f6zel bir form\u00fclle kural uygulaman\u0131za olanak tan\u0131yan ek bir se\u00e7ene\u011finiz vard\u0131r. <strong><mark class=\"has-inline-color\" style=\"background-color: #d3e3fd; color: #fd6c02;\">Ko\u015fullu bi\u00e7imlendirmeyi belirli bir \u015fekilde kullanmak i\u00e7in bu ayr\u0131nt\u0131l\u0131 e\u011fitimlerden daha fazla bilgi edinebilirsiniz:<\/mark><\/strong><\/p><div class=\"gb-container gb-container-bceb58a5\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bos-hucreler\/\">Bo\u015f h\u00fccrelere ko\u015fullu bi\u00e7imlendirme uygulama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sutunlari-karsilastir\/\">Ko\u015fullu bi\u00e7imlendirmeyi kullanarak iki s\u00fctunu kar\u015f\u0131la\u015ft\u0131rma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/baska-bir-hucre\/\">Ba\u015fka bir h\u00fccreye dayal\u0131 ko\u015fullu bi\u00e7imlendirme uygulama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/baska-bir-sutun\/\">Ba\u015fka bir s\u00fctuna dayal\u0131 olarak ko\u015fullu bi\u00e7imlendirme uygulama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kopyala\/\">Ko\u015fullu bi\u00e7imlendirmeyi bir aral\u0131ktan di\u011ferine kopyalama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tum-sutun\/\">S\u00fctunun tamam\u0131na ko\u015fullu bi\u00e7imlendirme uygulama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/\">Ko\u015fullu bi\u00e7imlendirmeyi kullanarak sat\u0131rlar\u0131 vurgulay\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/coklu-kosullar\/\">Ko\u015fullu bi\u00e7imlendirmede birden \u00e7ok ko\u015fulu uygulama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ise-yaramiyor\/\">Ko\u015fullu bi\u00e7imlendirme \u00e7al\u0131\u015fm\u0131yor<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hucre-metin-iceriyor\/\">Bir h\u00fccrenin Excel&#8217;de ko\u015fullu bi\u00e7imlendirmeye sahip belirli bir metin i\u00e7erip i\u00e7ermedi\u011fini vurgulay\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/2.-tarihe-gore\/\">Tarihe g\u00f6re ko\u015fullu bi\u00e7imlendirme uygulama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/renk-olcekleri\/\">Ko\u015fullu bi\u00e7imlendirmeyi kullanarak renk \u00f6l\u00e7ekleri uygulama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/veri-cubuklari\/\">Ko\u015fullu Bi\u00e7imlendirmeyi Kullanarak Excel&#8217;deki Veri \u00c7ubuklar\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kopyalari-bulma-2\/\">Ko\u015fullu bi\u00e7imlendirmeyi kullanarak Excel&#8217;de kopyalar\u0131 bulun ve vurgulay\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger-dogruysa-dur-2\/\">Ko\u015fullu Bi\u00e7imlendirmede Do\u011fruysa Durdur<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/geri-cekilmek\/\">Excel&#8217;de ko\u015fullu bi\u00e7imlendirmeyi kald\u0131rma<\/a><\/li><\/ul><\/div><h2 id=\"h-clear-rule\" class=\"wp-block-heading\"> Kural\u0131 temizle<\/h2><p> Ko\u015fullu bi\u00e7imlendirme bi\u00e7imlendirmedir ve de\u011ferleri silmeden onu bir h\u00fccreden veya h\u00fccre aral\u0131\u011f\u0131ndan kald\u0131rabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90830\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-supprimer-la-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"12-ko\u015fullu-bi\u00e7imlendirmeyi kald\u0131r\" width=\"464\" height=\"178\"><\/figure><\/div><p> Veya se\u00e7ili h\u00fccre veya aral\u0131ktaki <a href=\"https:\/\/exceladvisor.org\/tr\/bicimlendirmeyi-kaldir\/\">t\u00fcm bi\u00e7imlendirmeyi temizlemek<\/a> i\u00e7in Alt &gt; E &gt; A &gt; F klavye k\u0131sayolunu da kullanabilirsiniz.<\/p><h2 id=\"h-managing-rules\" class=\"wp-block-heading\"> Kural y\u00f6netimi<\/h2><p> Bu se\u00e7enek, bir \u00e7al\u0131\u015fma kitab\u0131ndaki veya se\u00e7imdeki t\u00fcm ko\u015fullu bi\u00e7imlendirme kurallar\u0131n\u0131 y\u00f6netmenize yard\u0131mc\u0131 olur. Kural Y\u00f6neticisi ile \u015funlar\u0131 yapabilirsiniz:<\/p><ol type=\"1\"><li> Bir kural\u0131 d\u00fczenleyin veya silin.<\/li><li> Bir kopya veya yeni bir kural olu\u015fturun.<\/li><li> Uygulanan de\u011feri aral\u0131\u011fa de\u011fi\u015ftirin.<\/li><li> Ayr\u0131ca kurallar\u0131n s\u0131ras\u0131n\u0131 da de\u011fi\u015ftirebilirsiniz.<\/li><\/ol><h3 id=\"h-stop-if-true\" class=\"wp-block-heading\"> Do\u011fruysa durdur<\/h3><p> Bir kural i\u00e7in stop is true se\u00e7ene\u011fini i\u015faretledi\u011finizde, bir h\u00fccrede bir ko\u015ful do\u011fru oldu\u011funda h\u00fccreye di\u011fer kurallar\u0131n uygulanmas\u0131 durdurulacakt\u0131r.<\/p><h2 id=\"h-using-cell-formatting-in-conditional-formatting\" class=\"wp-block-heading\"> Ko\u015fullu Bi\u00e7imlendirmede H\u00fccre Bi\u00e7imlendirmesini Kullanma<\/h2><p> Ko\u015fullu bi\u00e7imlendirme, h\u00fccre bi\u00e7imlendirme se\u00e7eneklerini kullanarak bir h\u00fccreye bi\u00e7imlendirme uygulaman\u0131za olanak tan\u0131r. Orada sahip oldu\u011funuz t\u00fcm bi\u00e7imlendirme se\u00e7eneklerini al\u0131rs\u0131n\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90831\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-cellules-utilisant-les-options-de-mise-en-forme-des-cellules-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"13 h\u00fccreli-bi\u00e7im-h\u00fccre-se\u00e7enekleri-ko\u015fullu-bi\u00e7imlendirmeyi kullanma\" width=\"570\" height=\"442\"><\/figure><\/div><ul><li> Say\u0131lar\u0131 bi\u00e7imlendirme<\/li><li> Yaz\u0131 tiplerini bi\u00e7imlendirme<\/li><li> S\u0131n\u0131r<\/li><li> H\u00fccreleri bi\u00e7imlendirme <\/li><\/ul><h2 id=\"h-identify-all-the-cells-where-conditional-formatting-is-applied\" class=\"wp-block-heading\"> Ko\u015fullu bi\u00e7imlendirmenin uyguland\u0131\u011f\u0131 t\u00fcm h\u00fccreleri tan\u0131mlay\u0131n<\/h2><p> Ana Sayfa &gt; Bul ve Se\u00e7 &gt; \u00d6zel&#8217;e Git b\u00f6l\u00fcm\u00fcnden \u00d6zel&#8217;e Git se\u00e7ene\u011fini a\u00e7t\u0131\u011f\u0131n\u0131zda. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90832\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-cellules-ou-la-mise-en-forme-conditionnelle-est-appliquee.png\" sizes=\"auto, \" srcset=\"\" alt=\"Ko\u015fullu bi\u00e7imlendirmenin uyguland\u0131\u011f\u0131 14 h\u00fccre\" width=\"390\" height=\"282\"><\/figure><\/div><p> \u00d6zel Git <a href=\"https:\/\/exceladvisor.org\/tr\/iletisim-kutusu\/\">ileti\u015fim kutusunda<\/a> Ko\u015fullu Bi\u00e7imlendirme&#8217;yi se\u00e7in ve ard\u0131ndan Tamam&#8217;a t\u0131klay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90833\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-selectionner-la-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"15-ko\u015fullu-bi\u00e7imlendirmeyi se\u00e7me\" width=\"300\" height=\"361\"><\/figure><\/div><p> Ve Tamam&#8217;a t\u0131klad\u0131\u011f\u0131n\u0131z anda ko\u015fullu bi\u00e7imlendirmenin uyguland\u0131\u011f\u0131 h\u00fccreleri se\u00e7er. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90834\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/16-cellules-ou-la-mise-en-forme-conditionnelle-est-appliquee.png\" sizes=\"auto, \" srcset=\"\" alt=\"Ko\u015fullu bi\u00e7imlendirmenin uyguland\u0131\u011f\u0131 16 h\u00fccre\" width=\"398\" height=\"235\"><\/figure><\/div><h2 id=\"h-few-points-to-consider-before-using-conditional-formatting\" class=\"wp-block-heading\"> Ko\u015fullu bi\u00e7imlendirmeyi kullanmadan \u00f6nce dikkate al\u0131nmas\u0131 gereken baz\u0131 noktalar.<\/h2><ol><li> \u00c7al\u0131\u015fma kitab\u0131ndaki a\u015f\u0131r\u0131 ko\u015fullu bi\u00e7imlendirme, onu hantal ve yava\u015f bir Excel dosyas\u0131 haline getirebilir.<\/li><li> Form\u00fclleri ko\u015fullu bi\u00e7imlendirmeyle kullan\u0131rken h\u00fccre referans\u0131na dikkat etmeniz gerekir.<\/li><li> Bir Excel \u00e7al\u0131\u015fma kitab\u0131n\u0131 ba\u015fka biriyle payla\u015f\u0131rsan\u0131z ko\u015fullu bi\u00e7imlendirme bozulmadan kal\u0131r.<\/li><\/ol>","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-1658","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 Ko\u015fullu Bi\u00e7imlendirme: Tam K\u0131lavuz<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitim, ko\u015fullu bi\u00e7imlendirmeyi \u00f6\u011frenmenize ve verilerinizi h\u0131zl\u0131 bir \u015fekilde analiz etmek i\u00e7in kullanmaya ba\u015flaman\u0131za yard\u0131mc\u0131 olacakt\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:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de Ko\u015fullu Bi\u00e7imlendirme: Tam K\u0131lavuz\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitim, ko\u015fullu bi\u00e7imlendirmeyi \u00f6\u011frenmenize ve verilerinizi h\u0131zl\u0131 bir \u015fekilde analiz etmek i\u00e7in kullanmaya ba\u015flaman\u0131za yard\u0131mc\u0131 olacakt\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comprendre-la-mise-en-forme-conditionnelle.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=\"6 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/\",\"name\":\"Excel&#39;de Ko\u015fullu Bi\u00e7imlendirme: Tam K\u0131lavuz\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comprendre-la-mise-en-forme-conditionnelle.png\",\"datePublished\":\"2023-11-13T00:34:06+00:00\",\"dateModified\":\"2023-12-10T06:01:32+00:00\",\"description\":\"Bu e\u011fitim, ko\u015fullu bi\u00e7imlendirmeyi \u00f6\u011frenmenize ve verilerinizi h\u0131zl\u0131 bir \u015fekilde analiz etmek i\u00e7in kullanmaya ba\u015flaman\u0131za yard\u0131mc\u0131 olacakt\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comprendre-la-mise-en-forme-conditionnelle.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comprendre-la-mise-en-forme-conditionnelle.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de ko\u015fullu bi\u00e7imlendirme: tam k\u0131lavuz\"}]},{\"@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 Ko\u015fullu Bi\u00e7imlendirme: Tam K\u0131lavuz","description":"Bu e\u011fitim, ko\u015fullu bi\u00e7imlendirmeyi \u00f6\u011frenmenize ve verilerinizi h\u0131zl\u0131 bir \u015fekilde analiz etmek i\u00e7in kullanmaya ba\u015flaman\u0131za yard\u0131mc\u0131 olacakt\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:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de Ko\u015fullu Bi\u00e7imlendirme: Tam K\u0131lavuz","og_description":"Bu e\u011fitim, ko\u015fullu bi\u00e7imlendirmeyi \u00f6\u011frenmenize ve verilerinizi h\u0131zl\u0131 bir \u015fekilde analiz etmek i\u00e7in kullanmaya ba\u015flaman\u0131za yard\u0131mc\u0131 olacakt\u0131r.","og_url":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:32+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comprendre-la-mise-en-forme-conditionnelle.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"6 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/","url":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/","name":"Excel&#39;de Ko\u015fullu Bi\u00e7imlendirme: Tam K\u0131lavuz","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comprendre-la-mise-en-forme-conditionnelle.png","datePublished":"2023-11-13T00:34:06+00:00","dateModified":"2023-12-10T06:01:32+00:00","description":"Bu e\u011fitim, ko\u015fullu bi\u00e7imlendirmeyi \u00f6\u011frenmenize ve verilerinizi h\u0131zl\u0131 bir \u015fekilde analiz etmek i\u00e7in kullanmaya ba\u015flaman\u0131za yard\u0131mc\u0131 olacakt\u0131r.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comprendre-la-mise-en-forme-conditionnelle.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comprendre-la-mise-en-forme-conditionnelle.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de ko\u015fullu bi\u00e7imlendirme: tam k\u0131lavuz"}]},{"@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\/1658","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=1658"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1658\/revisions"}],"predecessor-version":[{"id":2535,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1658\/revisions\/2535"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}