{"id":387099,"date":"2021-12-28T19:00:36","date_gmt":"2021-12-28T16:00:36","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-use-conditional-formatting-based-on-date-in-microsoft-excel\/"},"modified":"2021-12-28T19:00:36","modified_gmt":"2021-12-28T16:00:36","slug":"how-to-use-conditional-formatting-based-on-date-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-use-conditional-formatting-based-on-date-in-microsoft-excel\/","title":{"rendered":"#How to Use Conditional Formatting Based on Date in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a38fc871cdf0\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" 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: #dd3333;color:#dd3333\" 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><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a38fc871cdf0\" checked aria-label=\"Toggle\" \/><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:\/\/buradabiliyorum.com\/en\/how-to-use-conditional-formatting-based-on-date-in-microsoft-excel\/#Apply_a_Quick_Conditional_Formatting_Date_Rule\" >Apply a Quick Conditional Formatting Date Rule<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-conditional-formatting-based-on-date-in-microsoft-excel\/#Create_a_Custom_Conditional_Formatting_Date_Rule\" >Create a Custom Conditional Formatting Date Rule<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-conditional-formatting-based-on-date-in-microsoft-excel\/#Custom_Format_Method_One\" >Custom Format Method One<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-conditional-formatting-based-on-date-in-microsoft-excel\/#Custom_Format_Method_Two\" >Custom Format Method Two<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-conditional-formatting-based-on-date-in-microsoft-excel\/#Notes_on_Conditional_Formatting_Based_on_Date_in_Excel\" >Notes on Conditional Formatting Based on Date in Excel<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Use Conditional Formatting Based on Date in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Conditional formatting is a terrific feature for automatically <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>lying highlights or font formats to cells. If you have an Excel spreadsheet that contains dates, you can use this feature to make certain dates stand out and easy to spot.<\/p>\n<p>Whether you want to format past due dates for household bills or upcoming dates for a project plan, conditional formatting has you covered with both simple and custom options. Just set up the rule and watch your dates pop off of the sheet.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Apply_a_Quick_Conditional_Formatting_Date_Rule\"><\/span>Apply a Quick Conditional Formatting Date Rule<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to create a quick and easy conditional formatting rule, this is a convenient way to go. Open the sheet, select the cells you want to format, and head to the Home tab.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Use Conditional Formatting to Find Duplicate Data in Excel<\/em><\/strong><\/p>\n<p>In the Styles section of the ribbon, click the drop-down arrow for Conditional Formatting. Move your cursor to Highlight Cell Rules and choose \u201cA Date Occurring\u201d in the pop-out menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770878\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/HighlightCellRulesDateOccurring-ExcelConditionalFormattingDates.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select Conditional Formatting, Highlight Cell Rules, A Date Occurring\" width=\"650\" height=\"267\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>A small window appears for you to set up your rule. Use the drop-down list on the left to choose when the dates occur. You can pick from options like yesterday, tomorrow, last week, and next month.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770881\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/DateOccurringWhen-ExcelConditionalFormattingDates.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the timing for the date\" width=\"426\" height=\"285\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the drop-down list on the right, pick the formatting you\u2019d like to use. You can select from formats like a light red fill, yellow fill with dark yellow text, and a red border.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770880\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/DateOccurringFormat-ExcelConditionalFormattingDates.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the format for the date\" width=\"426\" height=\"230\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you finish, click \u201cOK\u201d to apply the conditional formatting rule to the selected cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770879\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/QuickRule-ExcelConditionalFormattingDates.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Apply the conditional formatting rule\" width=\"650\" height=\"168\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Create_a_Custom_Conditional_Formatting_Date_Rule\"><\/span>Create a Custom Conditional Formatting Date Rule<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Maybe you\u2019re not fond of the formatting choices available when creating the quick rule above. You can set up custom formatting instead. This allows you to format the cells most any way you like, including using more than one format for the cells like a specific font, border, and fill color.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Highlight Top- or Bottom-Ranked Values in Microsoft Excel<\/em><\/strong><\/p>\n<p>You can create a custom format two ways in Excel.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Custom_Format_Method_One\"><\/span>Custom Format Method One<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The first way is to start with the same setup as above. In the pop-up window where you create the rule, use the format drop-down box to pick \u201cCustom Format.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770883\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/DateOccurringCustomFormat-ExcelConditionalFormattingDates.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select Custom Format\" width=\"426\" height=\"240\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When the Format Cells window opens, use the tabs at the top for Font, Border, and Fill to create your custom format. Click \u201cOK\u201d when you finish.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770884\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/CustomFormatFill-ExcelConditionalFormattingDates.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose Font, Border, and Fill for the custom format\" width=\"575\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll see the custom format applied to the cells. Click \u201cOK\u201d in the small window to save the change.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770885\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/CustomFormatFillFont-ExcelConditionalFormattingDates.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Apply a custom format rule\" width=\"650\" height=\"168\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Custom_Format_Method_Two\"><\/span>Custom Format Method Two<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The second way to create a custom conditional formatting rule is to use the New Formatting Rule feature.<\/p>\n<p>Select the cells you want to format and go to the Home tab. Click the Conditional Formatting arrow and choose \u201cNew Rule.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770886\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/NewRule-ExcelConditionalFormattingDates.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select Conditional Formatting, New Rule\" width=\"650\" height=\"246\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the New Formatting Rule window, choose \u201cFormat Only Cells That Contain\u201d in the Select a Rule Type section.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770887\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/NewRuleCellsContain-ExcelConditionalFormattingDates.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select Format Only Cells That Contain\" width=\"650\" height=\"403\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>At the bottom of the window, select \u201cDates Occurring\u201d in the drop-down box on the left and choose the timeframe for the date to the right. Then, click \u201cFormat.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770888\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/NewRuleCellsContainFormat-ExcelConditionalFormattingDates.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose the timing for the date and click Format\" width=\"650\" height=\"403\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll see the same Format Cells box as above where you can use the Font, Border, and Fill tabs to create the custom format. When you finish, click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770889\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/CustomFormatBorder-ExcelConditionalFormattingDates.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose Font, Border, and Fill for the custom format\" width=\"650\" height=\"494\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The options you pick appear in the New Formatting Rule window as a preview. If you\u2019re happy with the format, click \u201cOK\u201d to save the rule.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770891\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/NewRulePreview-ExcelConditionalFormattingDates.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Review the new custom format rule\" width=\"650\" height=\"403\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll then see your cells updated with your custom format.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770890\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/NewRuleApplied-ExcelConditionalFormattingDates.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Apply the new custom format rule\" width=\"380\" height=\"225\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Add or Subtract Dates in Microsoft Excel<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Notes_on_Conditional_Formatting_Based_on_Date_in_Excel\"><\/span>Notes on Conditional Formatting Based on Date in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>With a conditional formatting rule in place, it applies to any edits you make to the dates in the cells. For example, say you formatted dates for next week. If you change any of the dates to yesterday, the formatting automatically disappears.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770892\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/EditDates-ExcelConditionalFormattingDates.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formatting changes when dates are edited\" width=\"650\" height=\"177\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can set up more than one rule for the same cells. Maybe you want to see all dates this month with a red font and all those next month with a green font. You would simply follow the same steps to create each rule and adjust the formatting accordingly.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770893\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/ThisNextMonth-ExcelConditionalFormattingDates.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Create more than one rule for the same set of cells\" width=\"650\" height=\"186\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For things like bills or tasks that are past their due dates or those you have coming up soon, you can spot them quickly with conditional formatting in Excel.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/770876\/how-to-use-conditional-formatting-based-on-date-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Use Conditional Formatting Based on Date in Microsoft Excel&#8221; Conditional formatting is a terrific feature for automatically applying highlights or font formats to cells. If you have an Excel spreadsheet that contains dates, you can use this feature to make certain dates stand out and easy to spot. Whether you want to format&#8230;<\/p>\n","protected":false},"author":1,"featured_media":387100,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-387099","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/387099","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=387099"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/387099\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/387100"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=387099"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=387099"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=387099"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}