{"id":2402,"date":"2013-11-03T20:47:33","date_gmt":"2013-11-03T19:47:33","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=2402"},"modified":"2020-09-04T09:45:23","modified_gmt":"2020-09-04T07:45:23","slug":"19-videonavod-jednoduche-podminene-formatovani","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/19-videonavod-jednoduche-podminene-formatovani\/","title":{"rendered":"19. Videotutorial &#8211; simple conditional formatting"},"content":{"rendered":"<p><\/p>\n<p style=\"text-align: justify;\">The\u00a0conditional formatting in Excel automatically help color the cells with numbers, text or dates according to the selected criteria. You do not have to search values or use\u00a0difficult filter, you can just see the colored cells. In addition, when changing values, conditional formatting immediately respond by repainting cells. You can format\u00a0individual cells and also the entire row. According colors we can even filter. How to turn it on and use a simple conditional formatting, you can see in this video. If this guide has helped you, become a fan on <a href=\"http:\/\/www.facebook.com\/itlektorcz\" target=\"_blank\" rel=\"noopener\">Facebook<\/a> and recommend this site to your friends, it\u00a0can be useful for them too.<\/p>\n<p style=\"text-align: justify;\"><em>Please note that this tutorial is presented in czech language.<\/em><\/p>\n<div class=\"potter-video\"><iframe title=\"#19 - Podm\u00edn\u011bn\u00e9 form\u00e1tov\u00e1n\u00ed\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/2s2L7lPQn3g?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/div>\n<p>Source file can be downloaded <a title=\"Podm\u00edn\u011bn\u00e9 form\u00e1tov\u00e1n\u00ed\" href=\"https:\/\/www.itlektor.cz\/soubory\/19-podminene-formatovani.xlsx\">here<\/a>.<\/p>\n<p><figure id=\"attachment_2403\" aria-describedby=\"caption-attachment-2403\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2013\/11\/podminene_formatovani.jpg\"><img decoding=\"async\" class=\"size-medium wp-image-2403 \" src=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2013\/11\/podminene_formatovani-300x175.jpg\" alt=\"Podm\u00edn\u011bn\u00e9 form\u00e1tov\u00e1n\u00ed\" width=\"300\" height=\"175\" title=\"\" srcset=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2013\/11\/podminene_formatovani-300x175.jpg 300w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2013\/11\/podminene_formatovani.jpg 848w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-2403\" class=\"wp-caption-text\">Conditional formatting<\/figcaption><\/figure><\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>The\u00a0conditional formatting in Excel automatically help color the cells with numbers, text or dates according to the selected criteria. You do not have to search values or use\u00a0difficult filter, you can just see the colored cells. In addition, when changing values, conditional formatting immediately respond by repainting cells. You can format\u00a0individual cells and also the [&hellip;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":2403,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[3,56],"tags":[10,58,50],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/2402"}],"collection":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/comments?post=2402"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/2402\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/2403"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=2402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=2402"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=2402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}