{"id":9596,"date":"2020-02-06T07:20:48","date_gmt":"2020-02-06T05:20:48","guid":{"rendered":"http:\/\/www.officetodo.com\/public\/?p=9596"},"modified":"2020-02-06T07:36:16","modified_gmt":"2020-02-06T05:36:16","slug":"how-to-change-cell-colors-automatically-excel-365","status":"publish","type":"post","link":"http:\/\/www.officetodo.com\/public\/how-to-change-cell-colors-automatically-excel-365\/","title":{"rendered":"How to change cell colors automatically? | Excel 365"},"content":{"rendered":"\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to change cell colors automatically? | Excel 365\" width=\"625\" height=\"352\" src=\"https:\/\/www.youtube.com\/embed\/84A0lcGzpPE?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Select column. Go to\nHome tab. Under Styles section choose Conditional Formatting.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"123\" src=\"http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-4-1024x123.png\" alt=\"Home \nInsert \nPage Layout \nCalibri \nFont \nFormulas Data \nReview \n-\u00afjsj \nView Help \nWrap Text \nMerge &amp; Center v \nAlignment \nGeneral \nNumber \n\/ConditiondI \nFormat as \nTable v \nNormal \nCalculation \nFormat Painter \nipboard \nBad \nCheck Cell \nStyles \" class=\"wp-image-9597\" srcset=\"http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-4-1024x123.png 1024w, http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-4-300x36.png 300w, http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-4-768x92.png 768w, http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-4-624x75.png 624w, http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-4.png 1094w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<!--more-->\n\n\n\n<p class=\"wp-block-paragraph\">Choose Highlight\nCells Rules and then Between\u2026<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"394\" height=\"452\" src=\"http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-5.png\" alt=\"Normal \nConditional Format as Calculation \nFormatting v Table v \nBad \nCheck Cell \nExpla \nHighlight Cells Rules &gt; \nGreater Thanm \nlop\/ Bottom Rules \nRule... \nClear Rules \nManage Rules... \nLess \nEqual Tom \nText that Containsm \nA Date Occurringm \nDuplicate Valuesm \nMore Rules... \" class=\"wp-image-9599\" srcset=\"http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-5.png 394w, http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-5-262x300.png 262w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Define range that should be colored.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"509\" height=\"139\" src=\"http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-3.png\" alt=\"Between \nFormat cells that are BETWEEN: \nand 7 \nwith \nLight Red Fill with Dark Red Text v \" class=\"wp-image-9598\" srcset=\"http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-3.png 509w, http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-3-300x82.png 300w\" sizes=\"auto, (max-width: 509px) 100vw, 509px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Under format\nselection choose Custom Format\u2026<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"510\" height=\"189\" src=\"http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-7.png\" alt=\"\" class=\"wp-image-9601\" srcset=\"http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-7.png 510w, http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-7-300x111.png 300w\" sizes=\"auto, (max-width: 510px) 100vw, 510px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Under Fill tab\nchoose suitable color and click OK<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"260\" height=\"308\" src=\"http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-8.png\" alt=\"\" class=\"wp-image-9602\" srcset=\"http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-8.png 260w, http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-8-253x300.png 253w\" sizes=\"auto, (max-width: 260px) 100vw, 260px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Confirm formatting\nby clicking OK.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"511\" height=\"141\" src=\"http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-6.png\" alt=\"\" class=\"wp-image-9600\" srcset=\"http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-6.png 511w, http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-6-300x83.png 300w\" sizes=\"auto, (max-width: 511px) 100vw, 511px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"234\" height=\"280\" src=\"http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-9.png\" alt=\"\" class=\"wp-image-9603\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Select column. Go to Home tab. Under Styles section choose Conditional Formatting.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3798],"tags":[3564,3703,3825,3508,3824,3673],"class_list":["post-9596","post","type-post","status-publish","format-standard","hentry","category-excel-365","tag-cell","tag-colors","tag-conditional","tag-excel","tag-excel-365","tag-formatting"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"Select column. Go to Home tab. Under Styles section choose Conditional Formatting. Choose Highlight Cells Rules and then Between\u2026 Define range that should be colored. Under format selection choose Custom Format\u2026 Under Fill tab choose suitable color and click OK Confirm formatting by clicking OK.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Karl\"\/>\n\t<link rel=\"canonical\" href=\"http:\/\/www.officetodo.com\/public\/how-to-change-cell-colors-automatically-excel-365\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-change-cell-colors-automatically-excel-365\\\/#article\",\"name\":\"How to change cell colors automatically? | Excel 365 | Office ToDo\",\"headline\":\"How to change cell colors automatically? | Excel 365\",\"author\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\"},\"publisher\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/image-4.png\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-change-cell-colors-automatically-excel-365\\\/#articleImage\",\"width\":1094,\"height\":131},\"datePublished\":\"2020-02-06T07:20:48+02:00\",\"dateModified\":\"2020-02-06T07:36:16+02:00\",\"inLanguage\":\"en\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-change-cell-colors-automatically-excel-365\\\/#webpage\"},\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-change-cell-colors-automatically-excel-365\\\/#webpage\"},\"articleSection\":\"Excel 365, cell, colors, conditional, excel, excel 365, formatting\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-change-cell-colors-automatically-excel-365\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.officetodo.com\\\/public\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/#listItem\",\"name\":\"MS Office\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/#listItem\",\"position\":2,\"name\":\"MS Office\",\"item\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/excel-365\\\/#listItem\",\"name\":\"Excel 365\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/excel-365\\\/#listItem\",\"position\":3,\"name\":\"Excel 365\",\"item\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/excel-365\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-change-cell-colors-automatically-excel-365\\\/#listItem\",\"name\":\"How to change cell colors automatically? | Excel 365\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/#listItem\",\"name\":\"MS Office\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-change-cell-colors-automatically-excel-365\\\/#listItem\",\"position\":4,\"name\":\"How to change cell colors automatically? | Excel 365\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/excel-365\\\/#listItem\",\"name\":\"Excel 365\"}}]},{\"@type\":\"Organization\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#organization\",\"name\":\"Office ToDo\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/\",\"name\":\"Karl\"},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-change-cell-colors-automatically-excel-365\\\/#webpage\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-change-cell-colors-automatically-excel-365\\\/\",\"name\":\"How to change cell colors automatically? | Excel 365 | Office ToDo\",\"description\":\"Select column. Go to Home tab. Under Styles section choose Conditional Formatting. Choose Highlight Cells Rules and then Between\\u2026 Define range that should be colored. Under format selection choose Custom Format\\u2026 Under Fill tab choose suitable color and click OK Confirm formatting by clicking OK.\",\"inLanguage\":\"en\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#website\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-change-cell-colors-automatically-excel-365\\\/#breadcrumblist\"},\"author\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\"},\"creator\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\"},\"datePublished\":\"2020-02-06T07:20:48+02:00\",\"dateModified\":\"2020-02-06T07:36:16+02:00\"},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#website\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/\",\"name\":\"Office ToDo\",\"inLanguage\":\"en\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"How to change cell colors automatically? | Excel 365 | Office ToDo","description":"Select column. Go to Home tab. Under Styles section choose Conditional Formatting. Choose Highlight Cells Rules and then Between\u2026 Define range that should be colored. Under format selection choose Custom Format\u2026 Under Fill tab choose suitable color and click OK Confirm formatting by clicking OK.","canonical_url":"http:\/\/www.officetodo.com\/public\/how-to-change-cell-colors-automatically-excel-365\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.officetodo.com\/public\/how-to-change-cell-colors-automatically-excel-365\/#article","name":"How to change cell colors automatically? | Excel 365 | Office ToDo","headline":"How to change cell colors automatically? | Excel 365","author":{"@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author"},"publisher":{"@id":"http:\/\/www.officetodo.com\/public\/#organization"},"image":{"@type":"ImageObject","url":"http:\/\/www.officetodo.com\/public\/wp-content\/uploads\/2020\/02\/image-4.png","@id":"http:\/\/www.officetodo.com\/public\/how-to-change-cell-colors-automatically-excel-365\/#articleImage","width":1094,"height":131},"datePublished":"2020-02-06T07:20:48+02:00","dateModified":"2020-02-06T07:36:16+02:00","inLanguage":"en","mainEntityOfPage":{"@id":"http:\/\/www.officetodo.com\/public\/how-to-change-cell-colors-automatically-excel-365\/#webpage"},"isPartOf":{"@id":"http:\/\/www.officetodo.com\/public\/how-to-change-cell-colors-automatically-excel-365\/#webpage"},"articleSection":"Excel 365, cell, colors, conditional, excel, excel 365, formatting"},{"@type":"BreadcrumbList","@id":"http:\/\/www.officetodo.com\/public\/how-to-change-cell-colors-automatically-excel-365\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public#listItem","position":1,"name":"Home","item":"http:\/\/www.officetodo.com\/public","nextItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/#listItem","name":"MS Office"}},{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/#listItem","position":2,"name":"MS Office","item":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/","nextItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-365\/#listItem","name":"Excel 365"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public#listItem","name":"Home"}},{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-365\/#listItem","position":3,"name":"Excel 365","item":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-365\/","nextItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/how-to-change-cell-colors-automatically-excel-365\/#listItem","name":"How to change cell colors automatically? | Excel 365"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/#listItem","name":"MS Office"}},{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/how-to-change-cell-colors-automatically-excel-365\/#listItem","position":4,"name":"How to change cell colors automatically? | Excel 365","previousItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-365\/#listItem","name":"Excel 365"}}]},{"@type":"Organization","@id":"http:\/\/www.officetodo.com\/public\/#organization","name":"Office ToDo","url":"http:\/\/www.officetodo.com\/public\/"},{"@type":"Person","@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author","url":"http:\/\/www.officetodo.com\/public\/author\/admin\/","name":"Karl"},{"@type":"WebPage","@id":"http:\/\/www.officetodo.com\/public\/how-to-change-cell-colors-automatically-excel-365\/#webpage","url":"http:\/\/www.officetodo.com\/public\/how-to-change-cell-colors-automatically-excel-365\/","name":"How to change cell colors automatically? | Excel 365 | Office ToDo","description":"Select column. Go to Home tab. Under Styles section choose Conditional Formatting. Choose Highlight Cells Rules and then Between\u2026 Define range that should be colored. Under format selection choose Custom Format\u2026 Under Fill tab choose suitable color and click OK Confirm formatting by clicking OK.","inLanguage":"en","isPartOf":{"@id":"http:\/\/www.officetodo.com\/public\/#website"},"breadcrumb":{"@id":"http:\/\/www.officetodo.com\/public\/how-to-change-cell-colors-automatically-excel-365\/#breadcrumblist"},"author":{"@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author"},"creator":{"@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author"},"datePublished":"2020-02-06T07:20:48+02:00","dateModified":"2020-02-06T07:36:16+02:00"},{"@type":"WebSite","@id":"http:\/\/www.officetodo.com\/public\/#website","url":"http:\/\/www.officetodo.com\/public\/","name":"Office ToDo","inLanguage":"en","publisher":{"@id":"http:\/\/www.officetodo.com\/public\/#organization"}}]}},"aioseo_meta_data":{"post_id":"9596","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"created":"2021-08-05 04:58:36","updated":"2026-05-27 00:19:19","ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.officetodo.com\/public\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/\" title=\"MS Office\">MS Office<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-365\/\" title=\"Excel 365\">Excel 365<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tHow to change cell colors automatically? | Excel 365\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"http:\/\/www.officetodo.com\/public"},{"label":"MS Office","link":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/"},{"label":"Excel 365","link":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-365\/"},{"label":"How to change cell colors automatically? | Excel 365","link":"http:\/\/www.officetodo.com\/public\/how-to-change-cell-colors-automatically-excel-365\/"}],"_links":{"self":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9596","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/comments?post=9596"}],"version-history":[{"count":3,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9596\/revisions"}],"predecessor-version":[{"id":9606,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9596\/revisions\/9606"}],"wp:attachment":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/media?parent=9596"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/categories?post=9596"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/tags?post=9596"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}