{"id":162,"date":"2012-08-16T09:24:02","date_gmt":"2012-08-16T09:24:02","guid":{"rendered":"http:\/\/blog.chury721.cz\/?p=162"},"modified":"2013-10-13T13:41:19","modified_gmt":"2013-10-13T13:41:19","slug":"excel-2007-podminene-formatovani-celeho-radku","status":"publish","type":"post","link":"https:\/\/blog.chury721.cz\/?p=162","title":{"rendered":"Excel 2007 &#8211; podm\u00edn\u011bn\u00e9 form\u00e1tov\u00e1n\u00ed cel\u00e9ho \u0159\u00e1dku"},"content":{"rendered":"<p>Excel 2007 &#8211; podm\u00edn\u011bn\u00e9 form\u00e1tov\u00e1n\u00ed cel\u00e9ho \u0159\u00e1dku s podm\u00ednkou na jednu bu\u0148ku. Jak n\u00e1zev napov\u00edd\u00e1 bude se jednat o to, aby n\u00e1m cel\u00fd \u0159\u00e1dek zm\u011bnil form\u00e1tov\u00e1n\u00ed v\u016f\u010di jedn\u00e9 bu\u0148ce.<\/p>\n<p>Viz obr\u00e1zky:<\/p>\n<p><a title=\"excel1\" href=\"http:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc1.png\" target=\"_blank\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-164\" title=\"exc1\" alt=\"excel1\" src=\"http:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc1-300x91.png\" width=\"300\" height=\"91\" srcset=\"https:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc1-300x91.png 300w, https:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc1-1024x310.png 1024w, https:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc1.png 1038w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/> <\/a> \u00a0 <a title=\"excel2\" href=\"http:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc2.png\" target=\"_blank\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-165\" title=\"exc2\" alt=\"exc2\" src=\"http:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc2-300x103.png\" width=\"300\" height=\"103\" srcset=\"https:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc2-300x103.png 300w, https:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc2-1024x351.png 1024w, https:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc2.png 1039w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/> <\/a><\/p>\n<pre>  Budeme m\u011bnit cel\u00fd druh\u00fd \u0159\u00e1dek \"2:2\" v\u016f\u010di bu\u0148ce \"B2\".<\/pre>\n<p>Ozna\u010d\u00edme cel\u00fd \u0159\u00e1dek 2: <a href=\"http:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc3.png\" target=\"_blank\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-170\" title=\"exc3\" alt=\"\" src=\"http:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc3.png\" width=\"1039\" height=\"71\" srcset=\"https:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc3.png 1039w, https:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc3-300x20.png 300w, https:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc3-1024x69.png 1024w\" sizes=\"(max-width: 1039px) 100vw, 1039px\" \/> <\/a><\/p>\n<p>Klikneme v z\u00e1lo\u017ece <strong> Dom\u016f <\/strong> na ikonu <strong> podm\u00edn\u011bn\u00e9 form\u00e1tov\u00e1n\u00ed <\/strong> a v n\u00ed klikneme na <strong> nov\u00e9 pravidlo <\/strong> . P\u0159eklikneme na \u0159\u00e1dek <strong> Ur\u010dit bu\u0148ky k form\u00e1tov\u00e1n\u00ed pomoc\u00ed vzorce <\/strong> . Zde zad\u00e1me hodnotu &#8220; =$B$2=0 &#8220; a zvol\u00edme si form\u00e1tov\u00e1n\u00ed.<\/p>\n<p><a href=\"http:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc5.png\" target=\"_blank\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-172\" title=\"exc5\" alt=\"\" src=\"http:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc5-300x144.png\" width=\"300\" height=\"144\" srcset=\"https:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc5-300x144.png 300w, https:\/\/blog.chury721.cz\/wp-content\/uploads\/2012\/08\/exc5.png 941w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/> <\/a> \u00a0V\u0161e by pak m\u011blo fungovat \ud83d\ude09<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel 2007 &#8211; podm\u00edn\u011bn\u00e9 form\u00e1tov\u00e1n\u00ed cel\u00e9ho \u0159\u00e1dku s podm\u00ednkou na jednu bu\u0148ku. Jak n\u00e1zev napov\u00edd\u00e1 bude se jednat o to, aby n\u00e1m cel\u00fd \u0159\u00e1dek zm\u011bnil form\u00e1tov\u00e1n\u00ed v\u016f\u010di jedn\u00e9 bu\u0148ce. Viz obr\u00e1zky: \u00a0 Budeme m\u011bnit cel\u00fd druh\u00fd \u0159\u00e1dek &#8222;2:2&#8220; v\u016f\u010di bu\u0148ce &#8222;B2&#8220;. Ozna\u010d\u00edme cel\u00fd \u0159\u00e1dek 2: Klikneme v z\u00e1lo\u017ece Dom\u016f na ikonu podm\u00edn\u011bn\u00e9 form\u00e1tov\u00e1n\u00ed a v [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-162","post","type-post","status-publish","format-standard","hentry","category-excel"],"_links":{"self":[{"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=\/wp\/v2\/posts\/162"}],"collection":[{"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=162"}],"version-history":[{"count":12,"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=\/wp\/v2\/posts\/162\/revisions"}],"predecessor-version":[{"id":485,"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=\/wp\/v2\/posts\/162\/revisions\/485"}],"wp:attachment":[{"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}