Conditional text based on formatting
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...