{"id":10861,"date":"2021-12-06T12:54:11","date_gmt":"2021-12-06T12:54:11","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=10861"},"modified":"2021-12-06T12:55:32","modified_gmt":"2021-12-06T12:55:32","slug":"conditional-formatting-a-text-box-in-a-chart","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/conditional-formatting-a-text-box-in-a-chart\/10102.html","title":{"rendered":"Conditional Formatting a Text Box In a Chart"},"content":{"rendered":"<p>I have a text box placed in a chart that links to another sheet\/cell for its content. The value is a percentage. I can format the source text using conditional format, but the formatting doesn&#8217;t carry forward into the text box. Is there a way to script\/macro or use if\/then for the value of a text box to change the font color? The text box is linked simply with &#8220;=Data!$J$7&#8221; ? Any help would be greatly appreciated!<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":14},"question-category":[53],"question_tags":[],"class_list":["post-10861","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\/10861","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=10861"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=10861"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=10861"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=10861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}