ExcelBanter - conditional formatting in text box

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - conditional formatting in text box (https://www.excelbanter.com/excel-discussion-misc-queries/164358-conditional-formatting-text-box.html)

pankaj

conditional formatting in text box

i want to use the text box for conditional formatting in ms excel like

i draw a text box A.

value = value 1 + value 2

value = 105

question is if value gets greater than 100 then the text box A text becomes
RED

All times are GMT +1. The time now is 02:53 PM.