4 Replies Latest reply on Jul 10, 2013 8:08 AM by rickaltman

    Conditional text based on formatting

    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