Neyse ki, Ko\u015fullu Bi\u00e7imlendirme<\/strong> Se\u00e7enekleri’ndeki Yeni Kural<\/strong> \u00f6zelli\u011fini kullanarak bunu yapmak kolayd\u0131r.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n Excel’de a\u015fa\u011f\u0131daki iki basketbol tak\u0131m\u0131 listesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n Diyelim ki \u0130yi Tak\u0131mlar<\/strong> listesinde bulunan T\u00fcm Tak\u0131mlar<\/strong> listesindeki her h\u00fccreyi vurgulamak istiyoruz.<\/span><\/p>\n Bunu yapmak i\u00e7in A2:A11<\/strong> h\u00fccre aral\u0131\u011f\u0131n\u0131 vurgulayabilir, ard\u0131ndan \u00fcst \u015feritteki Ana<\/strong> Sayfa sekmesindeki ko\u015fullu bi\u00e7imlendirme<\/strong> simgesine t\u0131klayabilir ve ard\u0131ndan a\u00e7\u0131l\u0131r men\u00fcden Yeni Kural’a<\/strong> t\u0131klayabiliriz:<\/span> <\/p>\n G\u00f6r\u00fcnt\u00fclenen yeni pencerede, Hangi h\u00fccrelerin bi\u00e7imlendirilece\u011fini belirlemek i\u00e7in form\u00fcl kullan se\u00e7ene\u011fini<\/strong> t\u0131klay\u0131n ve ard\u0131ndan a\u015fa\u011f\u0131daki form\u00fcl\u00fc girin:<\/span><\/p>\n Daha sonra Bi\u00e7im<\/strong> d\u00fc\u011fmesini t\u0131klay\u0131n ve ko\u015fullu bi\u00e7imlendirme i\u00e7in kullan\u0131lacak rengi se\u00e7in.<\/span><\/p>\n A\u00e7\u0131k ye\u015fili se\u00e7ece\u011fiz:<\/span> <\/p>\n Son olarak Tamam’\u0131<\/strong> t\u0131klay\u0131n.<\/span><\/p>\n \u0130yi<\/strong> Tak\u0131mlar listesinde bulunan T\u00fcm<\/strong> Tak\u0131mlar listesindeki her h\u00fccre otomatik olarak a\u00e7\u0131k ye\u015fil renkle vurgulanacakt\u0131r:<\/span> <\/p>\n Not<\/strong> : Bu \u00f6rnekte h\u00fccrelerin ko\u015fullu bi\u00e7imlendirmesi i\u00e7in a\u00e7\u0131k ye\u015fil dolgu kullanmay\u0131 se\u00e7iyoruz ancak siz istedi\u011finiz dolgu rengini se\u00e7ebilirsiniz.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’deki di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel: h\u00fccrenin liste metni i\u00e7erip i\u00e7ermedi\u011fini kontrol etme<\/a> \u00c7o\u011fu zaman, bir listede bulunan bir de\u011feri i\u00e7eriyorsa, Excel’deki bir h\u00fccreyi vurgulamak isteyebilirsiniz. Neyse ki, Ko\u015fullu Bi\u00e7imlendirme Se\u00e7enekleri’ndeki Yeni Kural \u00f6zelli\u011fini kullanarak bunu yapmak kolayd\u0131r. A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 g\u00f6sterir. \u00d6rnek: De\u011fer listede mevcutsa bir h\u00fccre nas\u0131l vurgulan\u0131r? Excel’de a\u015fa\u011f\u0131daki iki basketbol tak\u0131m\u0131 listesine sahip oldu\u011fumuzu varsayal\u0131m: Diyelim ki \u0130yi Tak\u0131mlar listesinde bulunan T\u00fcm […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4487","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n \u00d6rnek: De\u011fer listede mevcutsa bir h\u00fccre nas\u0131l vurgulan\u0131r?<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/generation-1.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/etat-neuf1.png\")
<\/p>\n =COUNTIF($C$2:$C$6,A2)>0<\/strong><\/pre>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/generation-2.png\")
<\/p>\n![\"Listede](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gen3.png\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel: listede bir de\u011fer aray\u0131n ve evet veya hay\u0131r de\u011ferini d\u00f6nd\u00fcr\u00fcn<\/a>
Excel: \u0130ki S\u00fctun Nas\u0131l E\u015fle\u015ftirilir ve \u00dc\u00e7\u00fcnc\u00fcs\u00fc D\u00f6nd\u00fcr\u00fcl\u00fcr<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"