{"id":1747,"date":"2023-11-07T15:58:06","date_gmt":"2023-11-07T15:58:06","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/"},"modified":"2023-12-10T06:02:20","modified_gmt":"2023-12-10T06:02:20","slug":"cizgileri-vurgula","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/","title":{"rendered":"Excel&#39;de sat\u0131rlar nas\u0131l vurgulan\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-229773776\"><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>Excel&#8217;de ko\u015fullu bi\u00e7imlendirmeyi kullanarak t\u00fcm sat\u0131r\u0131 vurgulamay\u0131 kullanabilirsiniz. Bir ko\u015ful do\u011fru oldu\u011funda sat\u0131r\u0131n belirtilen renkle vurgulanmas\u0131 gerekir. \u00d6rne\u011fin a\u015fa\u011f\u0131da stok verilerinin yer ald\u0131\u011f\u0131 bir tablomuz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90896\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mettre-en-surbrillance-les-lignes-a-laide-de-la-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"ko\u015fullu-bi\u00e7imlendirme kullanan-vurgu-sat\u0131rlar\u0131\" width=\"544\" height=\"304\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 1. Bir de\u011feri (metni) temel alarak bir sat\u0131r\u0131 vurgulay\u0131n<\/h2><ol><li> Tablonun tamam\u0131n\u0131, t\u00fcm sat\u0131rlar\u0131 ve s\u00fctunlar\u0131 se\u00e7in. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-t\u00fcm sat\u0131rlar\u0131 ve s\u00fctunlar\u0131 se\u00e7\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-selectionner-toutes-les-lignes-et-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"2-select-all-rows-and-columns\" width=\"493\" height=\"273\"><\/li><li> Ko\u015fullu Bi\u00e7imlendirme &gt; Yeni Kural&#8217;a gidin. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-ko\u015fullu-bi\u00e7imlendirme-yeni-kural\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-mise-en-forme-conditionnelle-nouvelle-regle-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"3-conditional-formatting-new-rule\" width=\"424\" height=\"431\"><\/li><li> Yeni kural ileti\u015fim kutusunda \u201cHangi h\u00fccrenin bi\u00e7imlendirilece\u011fini belirlemek i\u00e7in form\u00fcl kullan\u2026\u201d se\u00e7ene\u011fini t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-belirlemek i\u00e7in-bir-form\u00fcl-kullanmay\u0131-se\u00e7in\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-selectionner-utiliser-une-formule-pour-determiner.png\" sizes=\"auto, \" srcset=\"\" alt=\"4-select-use-a-formaula-to-determine\" width=\"568\" height=\"178\"><\/li><li> \u201cBu form\u00fcl\u00fcn do\u011fru oldu\u011fu de\u011ferleri bi\u00e7imlendir\u201d alan\u0131na =$B2= \u201cKanepeler\u201d form\u00fcl\u00fcn\u00fc girin. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-de\u011ferler bi\u00e7imindeki form\u00fcl\u00fc girin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-entrer-la-formule-dans-les-valeurs-de-format.png\" sizes=\"auto, \" srcset=\"\" alt=\"5-enter-formula-in-format-values\" width=\"596\" height=\"114\"><\/li><li> Daha sonra sat\u0131rlara uygulamak istedi\u011finiz s\u00fctunu belirtmek i\u00e7in format butonuna t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"6 t\u0131klamayla bi\u00e7imlendirme d\u00fc\u011fmesi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/bouton-format-6-clics-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"6-click-format-button\" width=\"571\" height=\"211\"><\/li><li> Sonunda, ko\u015fullu bi\u00e7imlendirmeyi uygulamak i\u00e7in Tamam&#8217;\u0131 ve ard\u0131ndan tekrar Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ol><p> Tamam&#8217;a t\u0131klad\u0131\u011f\u0131n\u0131zda \u00fcr\u00fcn ad\u0131n\u0131n &#8220;Kanepeler&#8221; oldu\u011fu sat\u0131rlar vurgulanacakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90902\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-mettre-en-evidence-les-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00e7izgileri vurgula\" width=\"534\" height=\"294\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 2. De\u011fere g\u00f6re bir sat\u0131r\u0131 vurgulay\u0131n (k\u0131smi metin)<\/h2><p> K\u0131smi metni kontrol etmek i\u00e7in bir form\u00fcl yazmak istiyorsan\u0131z ARAMA i\u015flevini kullan\u0131n. A\u015fa\u011f\u0131daki \u00f6rnekte \u00fcr\u00fcn s\u00fctununda &#8220;HS-&#8221; yazan t\u00fcm sat\u0131rlar\u0131 vurgulamam\u0131z gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90903\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-lignes-en-surbrillance-basees-sur-du-texte-partiel.png\" sizes=\"auto, \" srcset=\"\" alt=\"k\u0131smi metin tabanl\u0131 sat\u0131r vurgulama\" width=\"551\" height=\"398\"><\/figure><\/div><p> Ve Tamam&#8217;\u0131 t\u0131klad\u0131\u011f\u0131n\u0131z anda, k\u0131smi &#8220;HS-&#8221; metninin bulundu\u011fu t\u00fcm sat\u0131rlar vurgulan\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90904\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-mettre-en-surbrillance-toutes-les-lignes-avec-du-texte-partiel.png\" sizes=\"auto, \" srcset=\"\" alt=\"k\u0131smi metinle-t\u00fcm-sat\u0131rlar\u0131-vurgula\" width=\"476\" height=\"274\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 3. De\u011fere (say\u0131ya) g\u00f6re bir sat\u0131r\u0131 vurgulay\u0131n<\/h2><p> \u015eimdi, ya\u015flanma g\u00fcnlerinin 25 g\u00fcnden b\u00fcy\u00fck oldu\u011fu sat\u0131rlar\u0131 vurgulamak istedi\u011finizi varsayal\u0131m. Bu durumda yukar\u0131da uygulad\u0131\u011f\u0131m\u0131z ad\u0131mlar\u0131n ayn\u0131s\u0131n\u0131 uygulaman\u0131z gerekir. Ama form\u00fcl\u00fcn farkl\u0131 olmas\u0131 gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90905\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-lignes-de-surbrillance-basees-sur-des-nombres.png\" sizes=\"auto, \" srcset=\"\" alt=\"say\u0131lara dayal\u0131 sat\u0131rlar\u0131 vurgulama\" width=\"501\" height=\"362\"><\/figure><\/div><p> =$D2&gt;=25 form\u00fcl\u00fcn\u00fc kullanmal\u0131s\u0131n\u0131z. Bu form\u00fcl, h\u00fccre de\u011ferinin <a href=\"https:\/\/exceladvisor.org\/tr\/esitten-buyuk\/\">25&#8217;ten b\u00fcy\u00fck ve e\u015fit olup<\/a> olmad\u0131\u011f\u0131n\u0131 kontrol eder. E\u011fer \u00f6yleyse, tablo sat\u0131r\u0131n\u0131n tamam\u0131n\u0131 vurgulay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90906\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-mettre-en-surbrillance-toutes-les-lignes-avec-le-numero-de-reference-donne.png\" sizes=\"auto, \" srcset=\"\" alt=\"verilen referans numaras\u0131yla-t\u00fcm-sat\u0131rlar\u0131-vurgula\" width=\"452\" height=\"288\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 4. Birden fazla ko\u015fula g\u00f6re sat\u0131rlar\u0131 vurgulay\u0131n<\/h2><p> Birden fazla ko\u015fulu test etmek i\u00e7in bir form\u00fcl de olu\u015fturabilirsiniz. Form\u00fclde VE-VEYA i\u015flevlerini kullanabilirsiniz. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=AND($D2&gt;=25,$C2&gt;=15)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90907\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-lignes-de-surbrillance-basees-sur-plusieurs-conditions.png\" sizes=\"auto, \" srcset=\"\" alt=\"birden \u00e7ok ko\u015fula g\u00f6re sat\u0131rlar\u0131 vurgulay\u0131n\" width=\"537\" height=\"388\"><\/figure><\/div><p> Bu form\u00fcl\u00fc Yeni Kural ileti\u015fim kutusuna girdi\u011finizde sat\u0131rlar iki ko\u015fula g\u00f6re vurgulan\u0131r:<\/p><ul><li> G\u00fcn cinsinden ya\u015flanma 25&#8217;e e\u015fit veya daha b\u00fcy\u00fck olmal\u0131d\u0131r.<\/li><li> Miktar 15&#8217;ten b\u00fcy\u00fck veya ona e\u015fit olmal\u0131d\u0131r.<\/li><\/ul><p> Bu nedenle form\u00fclde, iki veya daha fazla ko\u015fulu ayn\u0131 anda test etmenize yard\u0131mc\u0131 olan ve yaln\u0131zca her iki ko\u015ful da DO\u011eRU oldu\u011funda DO\u011eRU de\u011ferini d\u00f6nd\u00fcren VE&#8217;yi kulland\u0131k.<\/p><h2 class=\"wp-block-heading\"> 5. H\u00fccrelerden herhangi biri bo\u015fsa sat\u0131r\u0131 vurgulay\u0131n<\/h2><p> Diyelim ki bir sat\u0131rdaki h\u00fccrelerden biri bo\u015fsa t\u00fcm sat\u0131r\u0131n sizin tan\u0131mlad\u0131\u011f\u0131n\u0131z bir renkle vurgulanmas\u0131 y\u00f6n\u00fcnde bir ko\u015ful olu\u015fturmak istiyorsunuz.<\/p><p> Verileri se\u00e7in, ard\u0131ndan Giri\u015f sekmesi &gt; Ko\u015fullu Bi\u00e7imlendirme &gt; Yeni Kural &gt; Hangi h\u00fccrelerin bi\u00e7imlendirilece\u011fini belirlemek i\u00e7in form\u00fcl kullanma se\u00e7ene\u011fine gidin; =E\u011eERSAY($A2:$D2,\u201d\u201d)&gt;0 form\u00fcl\u00fcn\u00fc girin ve ard\u0131ndan bi\u00e7imlendirmeyi belirtmek i\u00e7in Bi\u00e7im d\u00fc\u011fmesini t\u0131klay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90908\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-ligne-en-surbrillance-si-une-cellule-est-vide.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir h\u00fccre bo\u015fsa sat\u0131r\u0131 vurgula\" width=\"521\" height=\"376\"><\/figure><\/div><p> Ve bir kez Tamam&#8217;\u0131 t\u0131klatt\u0131\u011f\u0131n\u0131zda, tek bir h\u00fccrenin bile bo\u015f oldu\u011fu t\u00fcm sat\u0131rlar vurgulanacakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90909\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-lignes-en-surbrillance-avec-une-cellule-vide.png\" sizes=\"auto, \" srcset=\"\" alt=\"bo\u015f-h\u00fccreli-vurgulanan-\u00e7izgiler\" width=\"408\" height=\"277\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 6. A\u00e7\u0131l\u0131r listeyle dinamik de\u011fere sahip bir sat\u0131r\u0131 vurgulay\u0131n<\/h2><p> Ayr\u0131ca de\u011feri se\u00e7ebilece\u011finiz bir a\u00e7\u0131l\u0131r liste de olu\u015fturabilirsiniz; ko\u015fullu bi\u00e7imlendirme, sat\u0131rlar\u0131 vurgulamak i\u00e7in bu de\u011feri kullan\u0131r. \u0130lk \u00f6nce bir a\u00e7\u0131l\u0131r liste olu\u015fturun. Ard\u0131ndan Veri sekmesi &gt; Veri Do\u011frulama&#8217;ya gidin. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90910\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-lignes-de-surbrillance-avec-valeur-dynamique.png\" sizes=\"auto, \" srcset=\"\" alt=\"dinamik-de\u011fere sahip-sat\u0131rlar\u0131 vurgula\" width=\"622\" height=\"199\"><\/figure><\/div><p> Veri Do\u011frulama ileti\u015fim kutusunda &#8220;\u0130zin Ver&#8221; a\u00e7\u0131l\u0131r men\u00fcs\u00fcnden listeyi se\u00e7in ve a\u015fa\u011f\u0131daki form\u00fcl\u00fc girin: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=OFFSET($B$2, 0, 0, COUNTA($B$2:$B$11), 1)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90911\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/16-boite-de-dialogue-de-validation-des-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"veri do\u011frulama ileti\u015fim kutusu\" width=\"600\" height=\"396\"><\/figure><\/div><p> Son olarak, \u00fcr\u00fcn ad\u0131n\u0131 i\u00e7eren a\u00e7\u0131l\u0131r liste i\u00e7in 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-90912\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-liste-deroulante.png\" sizes=\"auto, \" srcset=\"\" alt=\"a\u00e7\u0131l\u0131r liste\" width=\"250\" height=\"184\"><\/figure><\/div><p> Bundan sonra verileri se\u00e7in ve yeni ko\u015ful bi\u00e7imlendirme kural\u0131 ileti\u015fim kutusunu a\u00e7\u0131n. Daha sonra \u201cHangi h\u00fccrelerin bi\u00e7imlendirilece\u011fini belirlemek i\u00e7in bir form\u00fcl kullan\u201d se\u00e7ene\u011fini t\u0131klay\u0131n ve ard\u0131ndan \u201cBu form\u00fcl\u00fcn do\u011fru oldu\u011fu de\u011ferleri bi\u00e7imlendir\u201d alan\u0131na a\u015fa\u011f\u0131daki form\u00fcl\u00fc girin.<\/p><p> \u00c7izgiyi vurgulamak i\u00e7in belirtmek istedi\u011finiz rengi belirtmek i\u00e7in Format d\u00fc\u011fmesini t\u0131klad\u0131\u011f\u0131n\u0131zdan emin olun. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90913\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/18-bouton-de-format-pour-specifier-la-couleur.png\" sizes=\"auto, \" srcset=\"\" alt=\"rengini belirtmek i\u00e7in bi\u00e7imlendirme d\u00fc\u011fmesi\" width=\"642\" height=\"370\"><\/figure><\/div><p> Sonunda kural\u0131 uygulamak i\u00e7in t\u0131klay\u0131n. A\u00e7\u0131l\u0131r men\u00fcdeki de\u011feri de\u011fi\u015ftirdi\u011finizde sat\u0131rlar, a\u00e7\u0131l\u0131r men\u00fcdeki de\u011fere g\u00f6re vurgulan\u0131r. Bu ko\u015fullu bi\u00e7imlendirme kural\u0131 bu nedenle h\u00fccrenin F1 h\u00fccresi a\u00e7\u0131l\u0131r listesindeki de\u011ferleri kullan\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90914\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/19-lignes-mises-en-surbrillance-en-fonction-des-valeurs-deroulantes.png\" sizes=\"auto, \" srcset=\"\" alt=\"vurgulanan \u00e7izgiler-a\u015fa\u011f\u0131-a\u015fa\u011f\u0131-de\u011ferlere dayal\u0131\" width=\"588\" height=\"298\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Excel dosyas\u0131n\u0131 al\u0131n<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mise-en-surbrillance-des-lignes-mise-en-forme-conditionnelle.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/div><div class=\"gb-container gb-container-6076ba72 gb-container-mt\"> <a class=\"gb-button gb-button-76e6a499 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/excelin-temelleri\/\">Excel&#8217;in temellerini \u00f6\u011frenin<\/a><h2 class=\"gb-headline gb-headline-a9e9e206 gb-headline-text gb-headline-mt-heading\"> <a href=\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirme\/\">Ko\u015fullu bi\u00e7imlendirme<\/a> hakk\u0131nda daha fazla bilgi edinin <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-790317cb gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-a9845ede\"><div class=\"gb-container gb-container-a9845ede\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/\">Pivot tabloya ko\u015fullu bi\u00e7imlendirme uygulama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/geri-cekilmek\/\">Ko\u015fullu Bi\u00e7imlendirmeyi Kald\u0131r<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bos-hucreler\/\">Excel&#8217;de Bo\u015f H\u00fccrelere Ko\u015fullu Bi\u00e7imlendirme Uygulay\u0131n<\/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><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-ec8ff319\"><div class=\"gb-container gb-container-ec8ff319\"><\/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-1747","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>\u25b7 Excel&#039;de sat\u0131rlar nas\u0131l vurgulan\u0131r? [Rehberlik etmek]<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitim, Excel&#039;de ko\u015fullu bi\u00e7imlendirmeyi kullanarak sat\u0131rlar\u0131 vurgulaman\u0131za yard\u0131mc\u0131 olur. Bunu kontrol edelim\u2026\" \/>\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\/cizgileri-vurgula\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Excel&#039;de sat\u0131rlar nas\u0131l vurgulan\u0131r? [Rehberlik etmek]\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitim, Excel&#039;de ko\u015fullu bi\u00e7imlendirmeyi kullanarak sat\u0131rlar\u0131 vurgulaman\u0131za yard\u0131mc\u0131 olur. Bunu kontrol edelim\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:02:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mettre-en-surbrillance-les-lignes-a-laide-de-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=\"4 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/\",\"name\":\"\u25b7 Excel&#39;de sat\u0131rlar nas\u0131l vurgulan\u0131r? [Rehberlik etmek]\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mettre-en-surbrillance-les-lignes-a-laide-de-la-mise-en-forme-conditionnelle.png\",\"datePublished\":\"2023-11-07T15:58:06+00:00\",\"dateModified\":\"2023-12-10T06:02:20+00:00\",\"description\":\"Bu e\u011fitim, Excel&#39;de ko\u015fullu bi\u00e7imlendirmeyi kullanarak sat\u0131rlar\u0131 vurgulaman\u0131za yard\u0131mc\u0131 olur. Bunu kontrol edelim\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mettre-en-surbrillance-les-lignes-a-laide-de-la-mise-en-forme-conditionnelle.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mettre-en-surbrillance-les-lignes-a-laide-de-la-mise-en-forme-conditionnelle.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de sat\u0131rlar nas\u0131l vurgulan\u0131r?\"}]},{\"@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":"\u25b7 Excel&#39;de sat\u0131rlar nas\u0131l vurgulan\u0131r? [Rehberlik etmek]","description":"Bu e\u011fitim, Excel&#39;de ko\u015fullu bi\u00e7imlendirmeyi kullanarak sat\u0131rlar\u0131 vurgulaman\u0131za yard\u0131mc\u0131 olur. Bunu kontrol edelim\u2026","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\/cizgileri-vurgula\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 Excel&#39;de sat\u0131rlar nas\u0131l vurgulan\u0131r? [Rehberlik etmek]","og_description":"Bu e\u011fitim, Excel&#39;de ko\u015fullu bi\u00e7imlendirmeyi kullanarak sat\u0131rlar\u0131 vurgulaman\u0131za yard\u0131mc\u0131 olur. Bunu kontrol edelim\u2026","og_url":"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:02:20+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mettre-en-surbrillance-les-lignes-a-laide-de-la-mise-en-forme-conditionnelle.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"4 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/","url":"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/","name":"\u25b7 Excel&#39;de sat\u0131rlar nas\u0131l vurgulan\u0131r? [Rehberlik etmek]","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mettre-en-surbrillance-les-lignes-a-laide-de-la-mise-en-forme-conditionnelle.png","datePublished":"2023-11-07T15:58:06+00:00","dateModified":"2023-12-10T06:02:20+00:00","description":"Bu e\u011fitim, Excel&#39;de ko\u015fullu bi\u00e7imlendirmeyi kullanarak sat\u0131rlar\u0131 vurgulaman\u0131za yard\u0131mc\u0131 olur. Bunu kontrol edelim\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mettre-en-surbrillance-les-lignes-a-laide-de-la-mise-en-forme-conditionnelle.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mettre-en-surbrillance-les-lignes-a-laide-de-la-mise-en-forme-conditionnelle.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/cizgileri-vurgula\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de sat\u0131rlar nas\u0131l vurgulan\u0131r?"}]},{"@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\/1747","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=1747"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1747\/revisions"}],"predecessor-version":[{"id":2591,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1747\/revisions\/2591"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}