AnsweredAssumed Answered

Conditional text based on formatting

Question asked by rickaltman on Jul 9, 2013
Latest reply on Jul 10, 2013 by rickaltman

Title

Conditional text based on formatting

Post

     I know that I can create a formula that formats text to be a certain color. I would like to know if I can create a formula whereby a field's display depends upon its format. 

     Let's say I have a text field called NAME and a calculated field called DISPLAY. Here is what I want: if NAME is set in standard black (RGB 0,0,0), then it would appear in DISPLAY. However, if I format the text in NAME to be say, RGB 100,100,100, then it would not appear in DISPLAY.

     Can this be done? Thanks...

      

     Rick A.
     Pleasanton CA

Outcomes