I'm trying to use a Formula-Text field to color another text field. Can you use decimal or RGB format in a formula?(ex. rgb(178, 218, 155))
I'm currently using the following formula:
"<font color=red>" & [Crew - Foreman]
I know you can use the name of the color or a hex format, but I wanted to know if it could be done with an RGB format and, if so, how? I have already tried replacing "red" in the formula with different variations of "rgb(178, 218, 155)" and nothing works. I can't seem to find anyone who demonstrates a way to do this.
Thanks in advance!