5 Replies Latest reply: Sep 15, 2016 11:54 PM by John Jackson RSS

    How to write multicolor texts/numbers in a Text Box

    John Jackson

      Hi Friends, I have the below challenge:

      The 3 Figures in the Text box below, I need to be green or red based on calculated condition using RGB Values. These figures will also be variables doing count/sum function. The text I need to be Black. Is it possible. The code I have for now is

       

      =' Total Inventory:    28,000   Backlog: 45%' &chr(10)& 'Current Inventory:  12,000'

       

       

       

      color font text box.PNG

       

      Thanks much.