{"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":"Uslovno formatiranje tabela"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 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\">Sadr\u017eaj<\/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<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\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;Ocenite post&quot;,&quot;legend&quot;:&quot;4.5\\\/5 - (2 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Uslovno formatiranje tabela&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>","protected":false},"excerpt":{"rendered":"<p>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 u<\/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 v27.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\":\"Uslovno formatiranje tabela\",\"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\":\"sr-SR\",\"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\":\"sr-SR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/uslovno-formatiranje-tabela\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sr-SR\",\"@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\":\"sr-SR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sr-SR\",\"@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":"Uslovno formatiranje tabela","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":"sr-SR","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":"sr-SR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/"]}]},{"@type":"ImageObject","inLanguage":"sr-SR","@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":"sr-SR"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"sr-SR","@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}]}}