{"id":6403,"date":"2021-11-19T05:41:57","date_gmt":"2021-11-19T05:41:57","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=6403"},"modified":"2021-11-19T05:42:34","modified_gmt":"2021-11-19T05:42:34","slug":"multiple-conditional-formatting-for-pivot-tables","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/multiple-conditional-formatting-for-pivot-tables\/17655.html","title":{"rendered":"Multiple Conditional Formatting For Pivot Tables"},"content":{"rendered":"<p>I am working in a pivot table within excel 2010. There are three columns I am working with, 2 of which are dates, the third is a column with a number. I am trying to find the difference between the first two dates and if the difference is larger than the third column with the number, I would like to format it a certain way within the conditional formatting options. The true issue is that every formula I know, gets messed up when the pivot table changes. I need something that stays consistent within the pivot table&#8217;s data changes.<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":3},"question-category":[53],"question_tags":[],"class_list":["post-6403","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/6403","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=6403"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=6403"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=6403"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=6403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}