{"id":1809,"date":"2023-11-03T03:25:57","date_gmt":"2023-11-03T03:25:57","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/"},"modified":"2023-12-10T06:04:56","modified_gmt":"2023-12-10T06:04:56","slug":"kosullu-bicimlendirmeyi-uygula","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/","title":{"rendered":"Pivot tabloda ko\u015fullu bi\u00e7imlendirme"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3786169059\"><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>Pivot tablonun verileri analiz etmek ve \u00f6zetlemek i\u00e7in en \u00f6nemli ara\u00e7lardan biri oldu\u011funu biliyorsunuz.<\/p><p> Pivot tablolar\u0131 kullanarak anl\u0131k raporlar olu\u015fturabilirsiniz. Daha \u00e7ekici hale getirmek i\u00e7in pivot tabloya ko\u015fullu bi\u00e7imlendirme uygulayabilirsiniz. H\u00fccreleri vurgulamak i\u00e7in pivot tabloda ko\u015fullu bi\u00e7imlendirmeyi uygulad\u0131\u011f\u0131m yere bak\u0131n. <\/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-dans-un-tableau-croise-dynamique-a-laide-dun-segment-1.gif\" sizes=\"\" srcset=\"\" alt=\"dilimleyici kullanarak pivot tabloya ko\u015fullu bi\u00e7imlendirme uygulama\"><\/figure><\/div><p> T\u00fcm eyaletleri dilimleyiciyle filtreledi\u011finizde en y\u00fcksek miktara sahip \u015fehri ve en d\u00fc\u015f\u00fck miktara sahip \u015fehri vurgulayacakt\u0131r. Ve bug\u00fcn bu makalede ko\u015fullu bi\u00e7imlendirmenin bir pivot tabloya nas\u0131l uygulanaca\u011f\u0131n\u0131 ve onu kullanman\u0131n t\u00fcm olas\u0131 yollar\u0131n\u0131 \u00f6\u011freneceksiniz.<\/p><p class=\"qt-tip\"> <strong>Not:<\/strong> Pivot tablolar <a href=\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/\">ORTA EXCEL BECER\u0130LER\u0130N\u0130N<\/a> bir par\u00e7as\u0131d\u0131r.<\/p><h2 id=\"tab-con-8\" class=\"wp-block-heading\"> Pivot tabloya ko\u015fullu bi\u00e7imlendirme uygulama ad\u0131mlar\u0131<\/h2><p> Pivot tabloya ko\u015fullu bi\u00e7imlendirme uygulamak ilk bak\u0131\u015fta zor g\u00f6r\u00fcnebilir, ancak ger\u00e7ekte basit ve kolayd\u0131r. A\u015fa\u011f\u0131daki pivot tabloda \u201cay\u201d de\u011ferlerine <strong>\u201c3 renkli skala\u201d<\/strong> uygulaman\u0131z gerekmektedir. Bu ad\u0131mlar\u0131 takip edelim. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Mise-en-forme-conditionnelle-de-lechelle-de-couleurs-dans-le-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"Pivot tabloda renk skalas\u0131n\u0131n ko\u015fullu bi\u00e7imlendirilmesi\"><\/figure><\/div><ol id=\"block-0079eb36-ef71-452d-adbf-61da7344d8e6\" class=\"block-editor-rich-text__editable block-editor-block-list__block wp-block is-selected rich-text\" tabindex=\"0\" role=\"group\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Block: List\" data-block=\"0079eb36-ef71-452d-adbf-61da7344d8e6\" data-type=\"core\/list\" data-title=\"List\"><li> \u00d6ncelikle ay de\u011feri olan h\u00fccrelerden birini se\u00e7in. <br><img decoding=\"async\" title=\"H\u00fccre Se\u00e7me-Ko\u015fullu-Bi\u00e7imlendirme-\u00d6zet Tabloda\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Selectionnez-la-cellule-pour-la-mise-en-forme-conditionnelle-dans-le-tableau-croise-dynamique.png\" sizes=\"\" srcset=\"\" alt=\"select cell to conditional formatting in pivot table\"><\/li><li> Ard\u0131ndan Ana Sayfa sekmesine gidin \u2192 Stiller \u2192 Ko\u015fullu Bi\u00e7imlendirme \u2192 Yeni Kural <br><img decoding=\"async\" title=\"Pivot Tabloda-Yeni-Kural-Uygulanacak-Ko\u015fullu-Bi\u00e7imlendirmeyi Se\u00e7in\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Selectionnez-une-nouvelle-regle-pour-appliquer-la-mise-en-forme-conditionnelle-dans-le-tableau-croise-dynamique.png\" sizes=\"\" srcset=\"\" alt=\"select new rule to apply conditional formatting in pivot table\"><\/li><li> Burada pivot tabloya ko\u015fullu bi\u00e7imlendirme uygulamak i\u00e7in bir a\u00e7\u0131l\u0131r pencere g\u00f6receksiniz. <br><img decoding=\"async\" title=\"Pivot Tabloda Uygulanacak Ko\u015fullu Bi\u00e7imlendirme Penceresi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fenetre-contextuelle-pour-appliquer-une-mise-en-forme-conditionnelle-dans-un-tableau-croise-dynamique.png\" sizes=\"\" srcset=\"\" alt=\"pop window to apply conditional formatting in pivot table\"><\/li><li> Bu a\u00e7\u0131l\u0131r pencerede, pivot tabloda ko\u015fullu bi\u00e7imlendirmeyi uygulamak i\u00e7in \u00fc\u00e7 farkl\u0131 se\u00e7ene\u011finiz vard\u0131r.<ul data-unit=\"px\"><li> Se\u00e7ili h\u00fccre: Ko\u015fullu bi\u00e7imlendirmeyi yaln\u0131zca se\u00e7ilen h\u00fccreye uygulamak i\u00e7in bu se\u00e7ene\u011fi kullan\u0131n.<\/li><li> &#8220;Tutar&#8221; de\u011ferlerini g\u00f6steren t\u00fcm h\u00fccreler: Tutar de\u011ferlerini i\u00e7eren t\u00fcm h\u00fccreler.<\/li><li> &#8220;Ay&#8221; i\u00e7in &#8220;tutar&#8221; de\u011ferlerini g\u00f6steren t\u00fcm h\u00fccreler: Tutar de\u011feri olan ancak yaln\u0131zca aylar i\u00e7in olan t\u00fcm h\u00fccreler. <br><img decoding=\"async\" title=\"Pivot tablodaki ko\u015fullu bi\u00e7imlendirmeyi uygulamak i\u00e7in \u00fc\u00e7 se\u00e7enek\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Trois-options-pour-appliquer-une-mise-en-forme-conditionnelle-dans-un-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"three options to apply conditional formatting in pivot table\"><\/li><\/ul><\/li><li> \u201cAy\u201d i\u00e7in \u201cTutar\u201d de\u011ferlerini g\u00f6steren t\u00fcm h\u00fccreleri se\u00e7in.<\/li><li> \u201cKural A\u00e7\u0131klamas\u0131n\u0131 D\u00fczenle\u201d b\u00f6l\u00fcm\u00fcnde 3 renkli \u00f6l\u00e7e\u011fi se\u00e7in.<\/li><li> Minimum, medyan ve maksimum t\u00fcr\u00fcn\u00fc y\u00fczde olarak de\u011fi\u015ftirin. Daha sonra \u00fc\u00e7\u00fc i\u00e7in de bir renk se\u00e7in. <br><img decoding=\"async\" title=\"Se\u00e7-Se\u00e7enekler-Uygula-Ko\u015fullu-Bi\u00e7imlendirme-\u00d6zet Tabloda\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Selectionnez-les-options-pour-appliquer-la-mise-en-forme-conditionnelle-dans-le-tableau-croise-dynamique.png\" sizes=\"\" srcset=\"\" alt=\"select options to apply conditional formatting in pivot table\"><\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"D\u00f6nd\u00fcr\u00fclebilir-ko\u015fullu-bi\u00e7imlendirmeli PivotTable\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Tableau-croise-dynamique-avec-mise-en-forme-conditionnelle-dans-le-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"pivot table with conditional formatting in pivot table\"><\/li><\/ol><p> Yukar\u0131daki pivot tabloda h\u00fccrelere ayl\u0131k olarak 3 renkli formatlama uygulad\u0131n\u0131z. Bu bi\u00e7imlendirmeyi kullanarak hangi ay\u0131n di\u011ferlerinden daha fazla gelir elde etti\u011fini kolayca analiz edebilirsiniz.<\/p><p> <strong>\u0130lgili: <a href=\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/\">Excel&#8217;de Ko\u015fullu Bi\u00e7imlendirmeye \u0130li\u015fkin Tam K\u0131lavuz<\/a><\/strong><\/p><h2 id=\"tab-con-9\" class=\"wp-block-heading\"> \u00d6rnekler: PivotTable&#8217;da Ko\u015fullu Formatlama Uygulama<\/h2><p> Pivot tabloda ko\u015fullu bi\u00e7imlendirmeyi kullanmak ak\u0131ll\u0131ca bir harekettir ve bunu bir\u00e7ok farkl\u0131 \u015fekilde kullanabilirsiniz. \u0130\u015fte an\u0131nda \u00f6\u011frenebilece\u011finiz ve i\u015finizde uygulayabilece\u011finiz baz\u0131 \u00f6rneklerin listesi.<\/p><h3 id=\"tab-con-3\" class=\"wp-block-heading\"> 1. Filtrelerle Dinamik Ko\u015fullu Bi\u00e7imlendirme<\/h3><p> Pivotunuzda ko\u015fullu bi\u00e7imlendirmeyi kulland\u0131\u011f\u0131n\u0131zda dinamik bi\u00e7imlendirme gibi \u00e7al\u0131\u015f\u0131r. De\u011ferleri her filtreledi\u011finizde veya verileri de\u011fi\u015ftirdi\u011finizde, bu de\u011fi\u015fiklikle birlikte otomatik olarak g\u00fcncellenecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Mise-en-forme-conditionnelle-dynamique-dans-le-tableau-croise-dynamique.gif\" sizes=\"\" srcset=\"\" alt=\"pivot tabloda dinamik ko\u015fullu bi\u00e7imlendirme\"><\/figure><\/div><p> Yukar\u0131daki pivot tabloda, en y\u00fcksek de\u011fere sahip h\u00fccreyi vurgulamak i\u00e7in ko\u015fullu bi\u00e7imlendirme uygulad\u0131n\u0131z. 2014&#8217;e t\u0131klad\u0131\u011f\u0131n\u0131zda \u00dcr\u00fcn-B en y\u00fcksek sat\u0131\u015f adedine sahipken, 2015&#8217;te \u00dcr\u00fcn-C en y\u00fcksek sat\u0131\u015f adedine sahip oluyor.<\/p><p> Pivot tablonuzu her filtreledi\u011finizde, otomatik olarak mevcut de\u011ferleri dikkate al\u0131r ve bi\u00e7imlendirme kural\u0131n\u0131 ona uygular.<\/p><p> <strong>\u0130lgili: <a href=\"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/\">Excel Dilimleyici<\/a><\/strong><\/p><h3 id=\"tab-con-4\" class=\"wp-block-heading\"> 2. Pivot tablodaki tek bir sat\u0131ra ko\u015fullu bi\u00e7imlendirme uygulay\u0131n<\/h3><p> A\u015fa\u011f\u0131daki pivot tabloda \u00fcr\u00fcne ve haftaya g\u00f6re sat\u0131\u015f verileriniz bulunmaktad\u0131r. Ve burada belirli bir \u00fcr\u00fcn i\u00e7in en y\u00fcksek sat\u0131\u015f adedine sahip olan h\u00fccreyi vurgulaman\u0131z gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Appliquer-la-mise-en-forme-conditionnelle-dans-le-tableau-croise-dynamique-dans-les-lignes-1.png\" sizes=\"\" srcset=\"\" alt=\"pivot tabloda sat\u0131rlara ko\u015fullu bi\u00e7imlendirme uygulama\"><\/figure><\/div><ol id=\"block-605c9d01-2b90-4c14-bb21-c0af936ef3f8\" class=\"block-editor-rich-text__editable block-editor-block-list__block wp-block is-selected rich-text\" tabindex=\"0\" role=\"group\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Block: List\" data-block=\"605c9d01-2b90-4c14-bb21-c0af936ef3f8\" data-type=\"core\/list\" data-title=\"List\"><li> H\u00fccrelerden birini se\u00e7in. <br><img decoding=\"async\" title=\"Uygulayacak H\u00fccreyi Se\u00e7in-Ko\u015fullu-Bi\u00e7imlendirme-\u0130\u00e7inde-\u00d6zet Tablo-Sat\u0131rda\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Selectionnez-la-cellule-pour-appliquer-la-mise-en-forme-conditionnelle-dans-le-tableau-croise-dynamique-dans-la-ligne.png\" sizes=\"\" srcset=\"\" alt=\"select cell to apply conditional formatting in pivot table in row\"><\/li><li> Ana Sayfa sekmesi \u2192 Stiller \u2192 Ko\u015fullu Bi\u00e7imlendirme \u2192 Yeni Kural&#8217;a gidin.<\/li><li> Kuraldan \u00fc\u00e7\u00fcnc\u00fc se\u00e7ene\u011fi se\u00e7in.<\/li><li> Ve \u201ckural se\u00e7\u201d t\u00fcr\u00fcnden \u201cYaln\u0131zca y\u00fcksek veya d\u00fc\u015f\u00fck s\u0131ralanan de\u011ferleri bi\u00e7imlendir\u201d se\u00e7ene\u011fini se\u00e7in.<\/li><li> Kural A\u00e7\u0131klamas\u0131n\u0131 D\u00fczenle&#8217;de giri\u015f kutusuna 1 girin ve a\u00e7\u0131l\u0131r men\u00fcden &#8220;her s\u00fctun grubu&#8221;nu se\u00e7in. <br><img decoding=\"async\" title=\"PivotTable 1'de ko\u015fullu bi\u00e7imlendirmeyi kullanarak \u00fcst de\u011ferleri arka arkaya vurgulay\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Mettre-en-surbrillance-les-principales-valeurs-dune-ligne-en-utilisant-la-mise-en-forme-conditionnelle-dans-le-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"highlight top values from a row by using conditional formatting in pivot table\"><\/li><li> \u0130stedi\u011finiz bi\u00e7imlendirmeyi uygulay\u0131n.<\/li><li> Tamam&#8217;\u0131 t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"Vurgulanan sat\u0131rlar i\u00e7in pivot tablonun ko\u015fullu bi\u00e7imlendirmesi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Mise-en-forme-conditionnelle-dans-le-tableau-croise-dynamique-pour-mettre-en-surbrillance-les-lignes.png\" sizes=\"\" srcset=\"\" alt=\"conditional formatting in pivot table for highlighting rows\"><\/li><\/ol><p> &#8220;Her s\u00fctun grubu&#8221;nu (Sat\u0131rlar) se\u00e7ti\u011finizde, ko\u015fullu bi\u00e7imlendirme yaln\u0131zca sat\u0131rdaki de\u011ferleri kar\u015f\u0131la\u015ft\u0131r\u0131r. Bu kural\u0131 sat\u0131rlar yerine s\u00fctunlara uygulamak istiyorsan\u0131z kural a\u00e7\u0131klamas\u0131nda &#8220;her sat\u0131r grubu&#8221; se\u00e7ene\u011fini se\u00e7ebilirsiniz.<\/p><p> Kural\u0131 t\u00fcm h\u00fccrelere uygulamak istiyorsan\u0131z a\u00e7\u0131l\u0131r listeden &#8220;t\u00fcm de\u011ferler&#8221;i se\u00e7meniz yeterlidir.<\/p><h3 id=\"tab-con-5\" class=\"wp-block-heading\"> 3. Ba\u015fka bir h\u00fccreyi temel alan pivot tabloda ko\u015fullu bi\u00e7imlendirme<\/h3><p> A\u015fa\u011f\u0131daki pivot tabloda veri \u00e7ubuklar\u0131n\u0131 uygulaman\u0131z gerekir. Ancak burada bir de\u011fi\u015fiklik var: farkl\u0131 bir h\u00fccrede bir hedef de\u011feriniz var ve veri \u00e7ubuklar\u0131n\u0131 bu hedef de\u011fere g\u00f6re uygulaman\u0131z gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Mise-en-forme-conditionnelle-dans-un-tableau-croise-dynamique-a-laide-dune-autre-cellule-1.png\" sizes=\"\" srcset=\"\" alt=\"ba\u015fka bir h\u00fccreyi kullanarak pivot tabloda ko\u015fullu bi\u00e7imlendirme\"><\/figure><\/div><p> \u0130\u015fte izlemeniz gereken ad\u0131mlar. <\/p><ol id=\"block-821e83ba-18e0-4b8e-9c38-dab00beb0af0\" class=\"block-editor-rich-text__editable block-editor-block-list__block wp-block is-selected rich-text\" tabindex=\"0\" role=\"group\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Block: List\" data-block=\"821e83ba-18e0-4b8e-9c38-dab00beb0af0\" data-type=\"core\/list\" data-title=\"List\"><li> \u00d6ncelikle bir h\u00fccre se\u00e7in ve Ana Sayfa sekmesi \u2192 Stiller \u2192 Ko\u015fullu Bi\u00e7imlendirme \u2192 Yeni Kural&#8217;a gidin.<\/li><li> Daha sonra, \u201cKurallar\u0131 uygula\u201d b\u00f6l\u00fcm\u00fcndeki \u00fc\u00e7\u00fcnc\u00fc se\u00e7ene\u011fi se\u00e7in ve kural t\u00fcr\u00fcnde \u201cT\u00fcm h\u00fccreleri de\u011ferlerine g\u00f6re bi\u00e7imlendir\u201d se\u00e7ene\u011fini se\u00e7in.<\/li><li> \u015eimdi kural a\u00e7\u0131klamas\u0131nda &#8220;Veri \u00c7ubu\u011fu&#8221;nu se\u00e7in ve T\u00fcr a\u00e7\u0131l\u0131r men\u00fcs\u00fcnden maksimum ve minimum say\u0131s\u0131n\u0131 se\u00e7in.<\/li><li> Buradan minimum de\u011fer kutusuna 0 girin ve maksimum giri\u015f kutusuna E2 h\u00fccre referans\u0131n\u0131 girin. <br><img decoding=\"async\" title=\"Veri \u00e7ubuklar\u0131n\u0131 uygulamak i\u00e7in pivot tabloda ko\u015fullu bi\u00e7imlendirme uygulay\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Appliquer-la-mise-en-forme-conditionnelle-dans-le-tableau-croise-dynamique-pour-appliquer-des-barres-de-donnees.png\" sizes=\"\" srcset=\"\" alt=\"apply conditional formatting in pivot table to apply data bars\"><\/li><li> Sonunda istedi\u011finiz veri \u00e7ubu\u011fu format\u0131n\u0131 belirtin ve Tamam&#8217;a t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"Veri \u00e7ubuklar\u0131 i\u00e7in ba\u015fka bir h\u00fccreyle pivot halinde ko\u015fullu bi\u00e7imlendirmeyi kullan\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-la-mise-en-forme-conditionnelle-dans-Pivot-avec-une-autre-cellule-pour-les-barres-de-donnees.png\" sizes=\"\" srcset=\"\" alt=\"use conditional formatting in pivot with another cell for data bars\"><\/li><\/ol><h3 id=\"tab-con-6\" class=\"wp-block-heading\"> 4. Pivot tablo alt toplamlar\u0131na ko\u015fullu bi\u00e7imlendirme uygulay\u0131n<\/h3><p> A\u015fa\u011f\u0131daki pivot tabloda farkl\u0131 aylara ve \u00fc\u00e7 ayl\u0131k d\u00f6nemlere ait sat\u0131\u015f tutar\u0131n\u0131 ve her \u00fc\u00e7 ayl\u0131k d\u00f6neme ait ara toplamlar\u0131 bulabilirsiniz. Burada alt toplamlara ayl\u0131k de\u011ferler yerine ko\u015fullu bi\u00e7imlendirme (simge seti) uygulaman\u0131z gerekiyor.<\/p><p> Bu ad\u0131mlar\u0131 takip et: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Appliquer-les-icones-au-sous-total-pour-utiliser-la-mise-en-forme-conditionnelle-dans-le-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"Pivot tabloda ko\u015fullu bi\u00e7imlendirmeyi kullanmak i\u00e7in simgeleri alt toplama uygulay\u0131n\"><\/figure><\/div><ol><li> \u00d6ncelikle bir h\u00fccre se\u00e7in ve Ana Sayfa sekmesi \u2192 Stiller \u2192 Ko\u015fullu Bi\u00e7imlendirme \u2192 Yeni Kural&#8217;a gidin.<\/li><li> Daha sonra, \u201cKurallar\u0131 uygula\u201d b\u00f6l\u00fcm\u00fcndeki \u00fc\u00e7\u00fcnc\u00fc se\u00e7ene\u011fi se\u00e7in ve kural t\u00fcr\u00fcnde \u201cT\u00fcm h\u00fccreleri de\u011ferlerine g\u00f6re bi\u00e7imlendir\u201d se\u00e7ene\u011fini se\u00e7in.<\/li><li> Kural a\u00e7\u0131klamas\u0131nda &#8220;Simge K\u00fcmeleri&#8221;ni se\u00e7in ve Simge Stili&#8217;ni se\u00e7in.<\/li><li> \u015eimdi, Simge G\u00f6r\u00fcnt\u00fcleme Cetveli&#8217;nde, alt toplamlara ko\u015fullu bi\u00e7imlendirme uygulamak i\u00e7in Y\u00fczde&#8217;yi kullan\u0131n.<\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ol><p> Bu simge setlerini ara toplamlara uygulad\u0131\u011f\u0131n\u0131zda %100 i\u00e7in en y\u00fcksek de\u011feri esas alacakt\u0131r. De\u011feri %67&#8217;nin \u00fczerinde olan h\u00fccreler ye\u015fil simge alacak, %33 ile %67 aras\u0131nda de\u011fere sahip olan h\u00fccreler sar\u0131 simge alacak ve alt\u0131ndaki di\u011fer h\u00fccreler k\u0131rm\u0131z\u0131 simge alacakt\u0131r.<\/p><p> Simgeleri ve y\u00fczdeleri gerekti\u011fi gibi de\u011fi\u015ftirebilirsiniz.<\/p><h3 id=\"tab-con-7\" class=\"wp-block-heading\"> 5. Pivot tablodaki bo\u015f h\u00fccrelere ko\u015fullu bi\u00e7imlendirme uygulay\u0131n<\/h3><p> <a href=\"https:\/\/exceladvisor.org\/tr\/bos-hucreleri-vurgula\/\">Bo\u015f h\u00fccreleri vurgulaman\u0131n<\/a> en iyi yolu ko\u015fullu bi\u00e7imlendirme kullanmakt\u0131r ve bunu pivot tabloda da kullanabilirsiniz. A\u015fa\u011f\u0131daki pivot tabloda baz\u0131 h\u00fccreler bo\u015ftur ve sat\u0131\u015f\u0131n olmad\u0131\u011f\u0131 h\u00fccrelere ko\u015fullu bi\u00e7imlendirme uygulaman\u0131z gerekmektedir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Mettez-en-surbrillance-les-cellules-vides-en-utilisant-la-mise-en-forme-conditionnelle-dans-le-tableau-croise-dynamique.png\" sizes=\"\" srcset=\"\" alt=\"Pivot tabloda ko\u015fullu bi\u00e7imlendirmeyi kullanarak bo\u015f h\u00fccreleri vurgulay\u0131n\"><\/figure><\/div><p> Bu basit ad\u0131mlar\u0131 izleyin. <\/p><ol id=\"block-4865b8ed-c4c2-464a-8b3b-2d4c54262c96\" class=\"block-editor-rich-text__editable block-editor-block-list__block wp-block is-selected rich-text\" tabindex=\"0\" role=\"group\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Block: List\" data-block=\"4865b8ed-c4c2-464a-8b3b-2d4c54262c96\" data-type=\"core\/list\" data-title=\"List\"><li> Ko\u015fullu Bi\u00e7imlendirme&#8217;de yeni kural\u0131 t\u0131klay\u0131n ve &#8220;Kurallara Uygula&#8221; b\u00f6l\u00fcm\u00fcndeki \u00fc\u00e7\u00fcnc\u00fc se\u00e7ene\u011fi se\u00e7in.<\/li><li> &#8220;Yaln\u0131zca \u015funu i\u00e7eren h\u00fccreleri bi\u00e7imlendir&#8221; kural t\u00fcr\u00fcn\u00fc se\u00e7in ve kural a\u00e7\u0131klamas\u0131nda &#8220;Bo\u015f&#8221;u se\u00e7in. <br><img decoding=\"async\" title=\"Bo\u015f h\u00fccreler i\u00e7in pivot tabloda ko\u015fullu bi\u00e7imlendirme uygulama\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Appliquer-la-mise-en-forme-conditionnelle-dans-le-tableau-croise-dynamique-pour-les-cellules-vides-1.png\" sizes=\"\" srcset=\"\" alt=\"apply conditional formatting in pivot table for blank cells\"><\/li><li> Bi\u00e7imlendirme i\u00e7in h\u00fccre rengini uygulay\u0131n ve Tamam&#8217;\u0131 t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"Bo\u015f h\u00fccreli-vurgulanm\u0131\u015f-1 ile ko\u015fullu-bi\u00e7imlendirme-pivot-tablo\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Mise-en-forme-conditionnelle-dans-un-tableau-croise-dynamique-avec-des-cellules-vides-en-surbrillance-1.png\" sizes=\"\" srcset=\"\" alt=\"conditional formatting in pivot table with blank cells highlighted\"><\/li><\/ol><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> \u00d6rnek dosya<\/h2><p> <a style=\"outline: none; display: inline-block;\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/mise-en-forme-conditionnelle-dans-un-tableau-croise-dynamique.xlsx\" rel=\"nofollow\" data-wpel-link=\"internal\">indirmek<\/a> <\/p><div class=\"wp-block-group main-page-bottom is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Daha Fazla PivotTable E\u011fitimi <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-29\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ekle-genel-toplami-sil\/\">Pivot tabloya genel toplam ekleme veya kald\u0131rma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/birikimli-toplam\/\">Pivot tabloya de\u011fi\u015fen toplam ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/otomatik-guncelleme-araligi\/\">Bir pivot tabloyu otomatik olarak g\u00fcncelleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/\">Pivot tablodaki form\u00fcller (hesaplanan alan ve \u00f6\u011fe)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/veri-kaynagini-degistir\/\">Excel&#8217;de pivot tablo i\u00e7in veri kayna\u011f\u0131n\u0131 de\u011fi\u015ftirme<\/a><\/li><\/ul><\/div><\/div><p> \u21e0 <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/\"><strong>Pivot Tablo E\u011fitimine<\/strong><\/a> Geri D\u00f6n<\/p><\/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-1809","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>Pivot tabloda ko\u015fullu bi\u00e7imlendirme<\/title>\n<meta name=\"description\" content=\"Pivot tabloda ko\u015fullu bi\u00e7imlendirmenin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenmek i\u00e7in bu kapsaml\u0131 k\u0131lavuzu kullan\u0131n.\" \/>\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-bicimlendirmeyi-uygula\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pivot tabloda ko\u015fullu bi\u00e7imlendirme\" \/>\n<meta property=\"og:description\" content=\"Pivot tabloda ko\u015fullu bi\u00e7imlendirmenin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenmek i\u00e7in bu kapsaml\u0131 k\u0131lavuzu kullan\u0131n.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:04:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/appliquer-une-mise-en-forme-conditionnelle-dans-un-tableau-croise-dynamique-a-laide-dun-segment-1.gif\" \/>\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-bicimlendirmeyi-uygula\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/\",\"name\":\"Pivot tabloda ko\u015fullu bi\u00e7imlendirme\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/appliquer-une-mise-en-forme-conditionnelle-dans-un-tableau-croise-dynamique-a-laide-dun-segment-1.gif\",\"datePublished\":\"2023-11-03T03:25:57+00:00\",\"dateModified\":\"2023-12-10T06:04:56+00:00\",\"description\":\"Pivot tabloda ko\u015fullu bi\u00e7imlendirmenin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenmek i\u00e7in bu kapsaml\u0131 k\u0131lavuzu kullan\u0131n.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/appliquer-une-mise-en-forme-conditionnelle-dans-un-tableau-croise-dynamique-a-laide-dun-segment-1.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/appliquer-une-mise-en-forme-conditionnelle-dans-un-tableau-croise-dynamique-a-laide-dun-segment-1.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pivot tabloda ko\u015fullu bi\u00e7imlendirme\"}]},{\"@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":"Pivot tabloda ko\u015fullu bi\u00e7imlendirme","description":"Pivot tabloda ko\u015fullu bi\u00e7imlendirmenin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenmek i\u00e7in bu kapsaml\u0131 k\u0131lavuzu kullan\u0131n.","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-bicimlendirmeyi-uygula\/","og_locale":"tr_TR","og_type":"article","og_title":"Pivot tabloda ko\u015fullu bi\u00e7imlendirme","og_description":"Pivot tabloda ko\u015fullu bi\u00e7imlendirmenin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenmek i\u00e7in bu kapsaml\u0131 k\u0131lavuzu kullan\u0131n.","og_url":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:04:56+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/appliquer-une-mise-en-forme-conditionnelle-dans-un-tableau-croise-dynamique-a-laide-dun-segment-1.gif","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-bicimlendirmeyi-uygula\/","url":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/","name":"Pivot tabloda ko\u015fullu bi\u00e7imlendirme","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/appliquer-une-mise-en-forme-conditionnelle-dans-un-tableau-croise-dynamique-a-laide-dun-segment-1.gif","datePublished":"2023-11-03T03:25:57+00:00","dateModified":"2023-12-10T06:04:56+00:00","description":"Pivot tabloda ko\u015fullu bi\u00e7imlendirmenin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenmek i\u00e7in bu kapsaml\u0131 k\u0131lavuzu kullan\u0131n.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/appliquer-une-mise-en-forme-conditionnelle-dans-un-tableau-croise-dynamique-a-laide-dun-segment-1.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/appliquer-une-mise-en-forme-conditionnelle-dans-un-tableau-croise-dynamique-a-laide-dun-segment-1.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Pivot tabloda ko\u015fullu bi\u00e7imlendirme"}]},{"@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\/1809","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=1809"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1809\/revisions"}],"predecessor-version":[{"id":2777,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1809\/revisions\/2777"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}