{"id":493202,"date":"2026-06-12T07:13:00","date_gmt":"2026-06-12T07:13:00","guid":{"rendered":"https:\/\/livelycity.com\/switzerland\/apply-conditional-formatting-based-on-another-cell-in-excel\/"},"modified":"2026-06-12T07:13:00","modified_gmt":"2026-06-12T07:13:00","slug":"apply-conditional-formatting-based-on-another-cell-in-excel","status":"publish","type":"post","link":"https:\/\/livelycity.com\/switzerland\/apply-conditional-formatting-based-on-another-cell-in-excel\/","title":{"rendered":"Apply Conditional Formatting Based on Another Cell in Excel"},"content":{"rendered":"<p>I have been working with Excel for over 10 years, and conditional formatting based on another cell is one of those features I use almost every single week. Let me walk you through all five methods, step by step.<\/p>\n<p><a href=\"https:\/\/excelchamps.com\/excel-basics\/conditional-formatting-another-cell\/\" target=\"_blank\" class=\"\">https:\/\/excelchamps.com\/excel-basics\/conditional-formatting-another-cell\/<\/a>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have been working with Excel for over 10 years, and conditional formatting based on another cell is one of those features I use almost&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[13],"tags":[],"class_list":["post-493202","post","type-post","status-publish","format-standard","hentry","category-kunsthaus-zurich-en","wpcat-13-id"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/posts\/493202","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/comments?post=493202"}],"version-history":[{"count":0,"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/posts\/493202\/revisions"}],"wp:attachment":[{"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/media?parent=493202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/categories?post=493202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/tags?post=493202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}