{"id":902,"date":"2017-09-22T17:35:43","date_gmt":"2017-09-22T15:35:43","guid":{"rendered":"http:\/\/kalkulacija.com\/wordpress\/?p=902"},"modified":"2022-05-07T08:44:47","modified_gmt":"2022-05-07T06:44:47","slug":"uslovno-formatiranje-tabela","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/","title":{"rendered":"[:sr]Uslovno formatiranje tabela[:en]Conditional formatting\u00a0tables[:]"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_87_1 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">[:sr]Sadr\u017eaj[:en] Contents[:]<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0d590e;color:#0d590e\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0d590e;color:#0d590e\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#Uslovno_formatiranje_tabela\" >Uslovno formatiranje tabela<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#Upotreba_uslovnog_formatiranja\" >Upotreba uslovnog formatiranja<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#Oznacavanje_duplikata_u_koloni\" >Ozna\u010davanje duplikata u koloni<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#Naglasavanje_vrednosti_na_osnovu_logickog_uslova\" >Nagla\u0161avanje vrednosti na osnovu logi\u010dkog uslova<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#Naglasavanje_najvecih_vrednosti\" >Nagla\u0161avanje najve\u0107ih vrednosti<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#Naglasavanje_gresaka\" >Nagla\u0161avanje gre\u0161aka<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#Naglasavanje_toplotnih_mapa_za_ocenu_rizika\" >Nagla\u0161avanje toplotnih mapa (za ocenu rizika)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#Naglasavanje_svakog_drugog_reda_ili_kolone\" >Nagla\u0161avanje svakog drugog reda ili kolone<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#Ponistavanje_uslovnih_formata_u_tabeli\" >Poni\u0161tavanje uslovnih formata u tabeli<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#Conditional_table_formatting\" >Conditional table formatting<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#What_is_the_profit\" >What is the profit<\/a><\/li><\/ul><\/nav><\/div>\n[:sr]\n<h2><span class=\"ez-toc-section\" id=\"Uslovno_formatiranje_tabela\"><\/span>Uslovno formatiranje tabela<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #ffcccc; text-align: center;\">\n<blockquote><p><strong>Napomena: <\/strong>U toku je dopuna.<\/p><\/blockquote>\n<\/div>\n<div><strong>Uslovno formatiranje tabela\u00a0 <\/strong>je postupak nagla\u0161avanja ili isticanja sadr\u017eaja tabele, naj\u010de\u0161\u0107e u vidu bojenja \u0107elije ili celog reda tabele. Nagla\u0161avanje ili isticnje sadr\u017eaja \u0107elije ili odabranog opsega \u0107elija naj\u010de\u0161\u0107e moraju da ispunjavaju odre\u0111eni uslov. Nagla\u0161avanje sadr\u017eaja \u0107elije zavisi od na\u0161eg izbora na\u010dina bojenja \u0107elije ili pomo\u0107u proporcionalnih traka, skala boja ili skupova ikona. Naj\u010de\u0161\u0107e je bojenje same \u0107elije ili<span style=\"font-size: medium;\">\u00a0opsega \u0107elija na osnovu uslova (ili kriterijuma).<\/span><\/div>\n<div><\/div>\n<p>Ukoliko je uslov ispunjen, opseg \u0107elija se oblikuje na osnovu tog uslova, a u suprotnom opseg \u0107elija ne\u0107e se formatirati na osnovu tog <a href=\"https:\/\/kalkulacija.com\/wordpress\/funkcija-u-excelu\/\">uslova<\/a>.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Upotreba_uslovnog_formatiranja\"><\/span>Upotreba uslovnog formatiranja<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div><span style=\"font-size: medium;\"><a href=\"https:\/\/www.excel-easy.com\/data-analysis\/conditional-formatting.html\" target=\"_blank\" rel=\"noopener\"><b>Conditional formatting<\/b>\u00a0<\/a>ili uslovno formatiranje se nalazi u meniju\u00a0<b>Home\u00a0<\/b>u grupi komandi\u00a0<b>Styles<\/b>.<\/span><\/div>\n<div><\/div>\n<div><span style=\"font-size: medium;\">Uslovno formatiranje mo\u017ee olak\u0161ati rad prilikom prebrojavanja ili izdvajanja studenata, koji su, na primer, polo\u017eili ispit ili koji su stariji od nekog godi\u0161ta ili su upisani odre\u0111ene godine.\u00a0<\/span><\/div>\n<div><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2894\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-01.png\" alt=\"\" width=\"900\" height=\"517\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-01.png 900w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-01-300x172.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-01-768x441.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/div>\n<div><span style=\"font-size: medium;\">\u00a0<\/span><\/div>\n<div><span style=\"font-size: medium;\">Postoji nekoliko\u00a0<b>vrsta\u00a0<\/b>uslovnog formatiranja:<\/span><\/div>\n<div><span style=\"font-size: medium;\">\u2022 Formatiranje svih \u0107elija pomo\u0107u dvobojne i trobojne skale<\/span><\/div>\n<div><span style=\"font-size: medium;\">\u2022 Formatiranje svih \u0107elija pomo\u0107u traka podataka<\/span><\/div>\n<div><span style=\"font-size: medium;\">\u2022 Formatiranje svih \u0107elija pomo\u0107u skupa ikona<\/span><\/div>\n<div><span style=\"font-size: medium;\">\u2022 Formatiranje samo vrednosti sa vrha ili dna rang liste<\/span><\/div>\n<div><span style=\"font-size: medium;\">\u2022 Formatiranje samo jedinstvenih ili duplih vrednosti\u00a0<\/span><\/div>\n<div><span style=\"font-size: medium;\">\u2022 Formatiranje samo vrednosti koje su iznad ili ispod proseka<\/span><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Oznacavanje_duplikata_u_koloni\"><\/span>Ozna\u010davanje duplikata u koloni<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div><span style=\"font-size: medium;\">\u00a0U<\/span><span style=\"font-size: medium;\">slovno formatiranje se mo\u017ee\u00a0<b>ukloniti\u00a0<\/b>pomo\u0107u komande<b>\u00a0Clear Rules<\/b>:<\/span><\/div>\n<div><span style=\"font-size: medium;\">\u00a0<\/span><b style=\"font-size: medium;\">Menjanje\u00a0<\/b><span style=\"font-size: medium;\">pravila se vr\u0161i pomo\u0107u komande\u00a0<\/span><b style=\"font-size: medium;\">Manage Rules<\/b><span style=\"font-size: medium;\">:<\/span><\/div>\n<div><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Naglasavanje_vrednosti_na_osnovu_logickog_uslova\"><\/span>Nagla\u0161avanje vrednosti na osnovu logi\u010dkog uslova<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2895\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-02.png\" alt=\"\" width=\"900\" height=\"517\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-02.png 900w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-02-300x172.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-02-768x441.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"Naglasavanje_najvecih_vrednosti\"><\/span>Nagla\u0161avanje najve\u0107ih vrednosti<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2896\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-03.png\" alt=\"\" width=\"900\" height=\"517\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-03.png 900w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-03-300x172.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-03-768x441.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"Naglasavanje_gresaka\"><\/span>Nagla\u0161avanje gre\u0161aka<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2897\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-04.png\" alt=\"\" width=\"900\" height=\"517\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-04.png 900w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-04-300x172.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-04-768x441.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"Naglasavanje_toplotnih_mapa_za_ocenu_rizika\"><\/span>Nagla\u0161avanje toplotnih mapa (za ocenu rizika)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2898\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-05.png\" alt=\"\" width=\"900\" height=\"517\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-05.png 900w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-05-300x172.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-05-768x441.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Naglasavanje_svakog_drugog_reda_ili_kolone\"><\/span>Nagla\u0161avanje svakog drugog reda ili kolone<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2899\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-06.png\" alt=\"\" width=\"900\" height=\"517\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-06.png 900w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-06-300x172.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-06-768x441.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"Ponistavanje_uslovnih_formata_u_tabeli\"><\/span>Poni\u0161tavanje uslovnih formata u tabeli<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div><span style=\"font-size: medium;\">\u00a0<\/span><\/div>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2900\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-07.png\" alt=\"\" width=\"900\" height=\"517\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-07.png 900w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-07-300x172.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-07-768x441.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/h3>\n[:en]\n<h2><span class=\"ez-toc-section\" id=\"Conditional_table_formatting\"><\/span>Conditional table formatting<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Conditional formatting highlights cells or a range of cells that meet certain conditions using data bars, color scales, and icon sets, while changing the appearance of the cell range based on conditions (or criteria). If the condition is met, the cell range is formatted based on that condition, and otherwise the cell range will not be formatted based on that condition.<br \/>\nConditional formatting or conditional formatting is located in the Home menu in the Styles command group.<br \/>\nConditional formatting can make it easier to count or separate students who, for example, have passed an exam or who are older than a year or enrolled in a particular year.<\/p>\n<p>There are several types of conditional formatting:<br \/>\n\u2022 Format all cells using two-color and three-color scales<br \/>\n\u2022 Format all cells using data tapes<br \/>\n\u2022 Format all cells using a set of icons<br \/>\n\u2022 Format only values \u200b\u200bfrom the top or bottom of the ranking list<br \/>\n\u2022 Format only unique or duplicate values<br \/>\n\u2022 Format only values \u200b\u200bthat are above or below average<\/p>\n<h2><span class=\"ez-toc-section\" id=\"What_is_the_profit\"><\/span>What is the profit<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Conditional formatting can be removed using the Clear Rules command:<\/p>\n<p>Changing the rules is done using the Rule Management command:[:]\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;902&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;2&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4.5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;[:sr] Ocenite [:en]Rate this [:]post&quot;,&quot;legend&quot;:&quot;4.5\\\/5 - (2 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;[:sr]Uslovno formatiranje tabela[:en]Conditional formatting\u00a0tables[:]&quot;,&quot;width&quot;:&quot;128&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 128px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            4.5\/5 - (2 votes)    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>[:sr] Uslovno formatiranje tabela Napomena: U toku je dopuna. Uslovno formatiranje tabela\u00a0 je postupak nagla\u0161avanja ili isticanja sadr\u017eaja tabele, naj\u010de\u0161\u0107e<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42,19],"tags":[64,65],"class_list":["post-902","post","type-post","status-publish","format-standard","hentry","category-napredni-excel","category-ekscel","tag-excel","tag-naglasavanja-sadrzaja"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Uslovno formatiranje tabela<\/title>\n<meta name=\"description\" content=\"Uslovno formatiranje tabela\u00a0 je postupak nagla\u0161avanja ili isticanja sadr\u017eaja tabele, naj\u010de\u0161\u0107e u vidu bojenja \u0107elije ili celog reda tabele.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Uslovno formatiranje tabela\" \/>\n<meta property=\"og:description\" content=\"Uslovno formatiranje tabela\u00a0 je postupak nagla\u0161avanja ili isticanja sadr\u017eaja tabele, naj\u010de\u0161\u0107e u vidu bojenja \u0107elije ili celog reda tabele.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/\" \/>\n<meta property=\"og:site_name\" content=\"Kalkulacija u osnovi svega!\" \/>\n<meta property=\"article:published_time\" content=\"2017-09-22T15:35:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-07T06:44:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-01.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/uslovno-formatiranje-tabela\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/uslovno-formatiranje-tabela\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"[:sr]Uslovno formatiranje tabela[:en]Conditional formatting\u00a0tables[:]\",\"datePublished\":\"2017-09-22T15:35:43+00:00\",\"dateModified\":\"2022-05-07T06:44:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/uslovno-formatiranje-tabela\\\/\"},\"wordCount\":482,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/uslovno-formatiranje-tabela\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/uslovno-formatiranje-01.png\",\"keywords\":[\"excel\",\"nagla\u0161avanja sadr\u017eaja\"],\"articleSection\":[\"Napredni Excel\",\"Poslovni Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/uslovno-formatiranje-tabela\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/uslovno-formatiranje-tabela\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/uslovno-formatiranje-tabela\\\/\",\"name\":\"Uslovno formatiranje tabela\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/uslovno-formatiranje-tabela\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/uslovno-formatiranje-tabela\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/uslovno-formatiranje-01.png\",\"datePublished\":\"2017-09-22T15:35:43+00:00\",\"dateModified\":\"2022-05-07T06:44:47+00:00\",\"description\":\"Uslovno formatiranje tabela\u00a0 je postupak nagla\u0161avanja ili isticanja sadr\u017eaja tabele, naj\u010de\u0161\u0107e u vidu bojenja \u0107elije ili celog reda tabele.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/uslovno-formatiranje-tabela\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/uslovno-formatiranje-tabela\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/uslovno-formatiranje-tabela\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/uslovno-formatiranje-01.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/uslovno-formatiranje-01.png\",\"width\":900,\"height\":517},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/uslovno-formatiranje-tabela\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Uslovno formatiranje tabela\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Kalkulacija u osnovi svega!\",\"description\":\"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Uslovno formatiranje tabela","description":"Uslovno formatiranje tabela\u00a0 je postupak nagla\u0161avanja ili isticanja sadr\u017eaja tabele, naj\u010de\u0161\u0107e u vidu bojenja \u0107elije ili celog reda tabele.","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:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/","og_locale":"en_US","og_type":"article","og_title":"Uslovno formatiranje tabela","og_description":"Uslovno formatiranje tabela\u00a0 je postupak nagla\u0161avanja ili isticanja sadr\u017eaja tabele, naj\u010de\u0161\u0107e u vidu bojenja \u0107elije ili celog reda tabele.","og_url":"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/","og_site_name":"Kalkulacija u osnovi svega!","article_published_time":"2017-09-22T15:35:43+00:00","article_modified_time":"2022-05-07T06:44:47+00:00","og_image":[{"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-01.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"[:sr]Uslovno formatiranje tabela[:en]Conditional formatting\u00a0tables[:]","datePublished":"2017-09-22T15:35:43+00:00","dateModified":"2022-05-07T06:44:47+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/"},"wordCount":482,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-01.png","keywords":["excel","nagla\u0161avanja sadr\u017eaja"],"articleSection":["Napredni Excel","Poslovni Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/","url":"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/","name":"Uslovno formatiranje tabela","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-01.png","datePublished":"2017-09-22T15:35:43+00:00","dateModified":"2022-05-07T06:44:47+00:00","description":"Uslovno formatiranje tabela\u00a0 je postupak nagla\u0161avanja ili isticanja sadr\u017eaja tabele, naj\u010de\u0161\u0107e u vidu bojenja \u0107elije ili celog reda tabele.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-01.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/uslovno-formatiranje-01.png","width":900,"height":517},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Uslovno formatiranje tabela"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Kalkulacija u osnovi svega!","description":"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/902","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/comments?post=902"}],"version-history":[{"count":39,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/902\/revisions"}],"predecessor-version":[{"id":2906,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/902\/revisions\/2906"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}