{"id":741,"date":"2018-03-14T18:07:38","date_gmt":"2018-03-14T12:07:38","guid":{"rendered":"http:\/\/xlfxs.com\/?p=741"},"modified":"2018-03-14T18:07:38","modified_gmt":"2018-03-14T12:07:38","slug":"highlight-dates-dynamically","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=741","title":{"rendered":"Highlight dates dynamically"},"content":{"rendered":"<p>Conditional formatting is another powerful feature in Excel, especially when you combine it with functions<\/p>\n<p>A simple function as in below if you set it up inside Conditional formatting, can do magic<\/p>\n<p><!--more--><\/p>\n<p>&nbsp;<\/p>\n<div id='gallery-1' class='gallery galleryid-741 gallery-columns-2 gallery-size-thumbnail'><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/xlfxs.com\/wp-content\/uploads\/2018\/03\/22-2.png'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/xlfxs.com\/wp-content\/uploads\/2018\/03\/22-2-150x150.png\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/xlfxs.com\/wp-content\/uploads\/2018\/03\/21-1-2.png'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/xlfxs.com\/wp-content\/uploads\/2018\/03\/21-1-2-150x150.png\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" \/><\/a>\n\t\t\t<\/div><\/figure>\n\t\t<\/div>\n\n<p>Attached spreadsheet below has two examples of how to use that formula to highlight the dates needed, you just need to think about the condition in your AND function, and then you good to go<\/p>\n<p>Example below will highlight columns B to E when cell in E is in the future and within the next 7 days<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1241\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/03\/Conditional-formatting-variable-related.png\" alt=\"Conditional formatting variable related.png\" width=\"1394\" height=\"766\" \/><\/p>\n<p>&nbsp;<\/p>\n<div class=\"row\">\n<div class=\"col-lg-6 col-md-6 col-sm-6 text-right\"><a class=\"btn btn-primary btn-lg\" title=\"HighlightDatesUsingConditionalFormatting\" href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/03\/HighlightDatesUsingConditionalFormatting.xlsx\"><i class=\"fa fa-download\"><\/i> Download spreadsheet<\/a><\/div>\n<div class=\"col-lg-6 col-md-6 col-sm-6\"><a class=\"btn btn-primary btn-lg\" href=\"https:\/\/1drv.ms\/x\/s!An4iomsT7EVO18tHtbySzwXBiC_TpA\" target=\"_blank\" rel=\"noopener\"><i class=\"fa fa-cloud\"><\/i> Excel Online version<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Conditional formatting is another powerful feature in Excel, especially when you combine it with functions A simple function as in below if you set it up inside Conditional formatting, can do magic<\/p>\n","protected":false},"author":1,"featured_media":1235,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[68,18,5,6,61],"tags":[],"class_list":["post-741","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-and","category-conditional-formatting","category-non-functions","category-standard_functions","category-today"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=741"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/741\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1235"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}