{"id":985,"date":"2017-04-20T18:54:27","date_gmt":"2017-04-20T16:54:27","guid":{"rendered":"http:\/\/skolarbbos.net\/?p=985"},"modified":"2021-06-07T07:57:45","modified_gmt":"2021-06-07T05:57:45","slug":"uslovno-formatiranje","status":"publish","type":"post","link":"https:\/\/skolarbbos.net\/?p=985","title":{"rendered":"Uslovno formatiranje"},"content":{"rendered":"<p>Uslovno formatiranje (engl. Conditional formatting) omogu\u0107ava da \u0107elije formatirate selektivno i automatski, zavisno od njihovog sadr\u017eaja. Na primer, mo\u017eete podesiti formatiranje tako da sve negativne vrednosti u podru\u010dju imaju svetlo\u017eutu pozadinu. Kada unesete ili izmenite vrednost u podru\u010dju, Excel \u0107e proceniti vrednost i proveriti pravila uslovnog formatiranja za \u0107eliju. Ukoliko je vrednost negativna, pozadina \u0107e biti obojena. Ukoliko nije, format ne\u0107e biti menjan.<\/p>\n<p>Uslovno formatiranje je koristan na\u010din da se brzo uo\u010de pogre\u0161no uneti podaci u \u0107elijama ili \u0107elije odre\u0111enog tipa. Format (kao \u0161to je svetlocrvena pozadina \u0107elije) mo\u017eete primeniti da bi se odre\u0111ene \u0107elije lak\u0161e raspoznavale.<\/p>\n<p><video controls=\"controls\" width=\"600\" height=\"400\"><source src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/04\/37. Conditional Formatting (uslovno formatiranje).mp4\" type=\"video\/mp4\" \/><\/video><\/p>\n<p><strong><a href=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/04\/37. Conditional Formatting (uslovno formatiranje).xlsx\">Ve\u017eba<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"Uslovno formatiranje (engl. Conditional formatting) omogu\u0107ava da \u0107elije formatirate selektivno i automatski,<a class=\"moretag\" href=\"https:\/\/skolarbbos.net\/?p=985\"> &lt;b&gt;[Nastavi sa \u010ditanjem...]&lt;\/b&gt;<\/a>","protected":false},"author":1,"featured_media":597,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-985","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel"],"_links":{"self":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/985","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=985"}],"version-history":[{"count":1,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/985\/revisions"}],"predecessor-version":[{"id":1204,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/985\/revisions\/1204"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/media\/597"}],"wp:attachment":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=985"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=985"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}