Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Can you use decimal or RGB format for colors in formulas?

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!

3 Replies

  • try this
    "<font style=\"color:rgb(178,218,155)\">" & [Crew - Foreman] & "</font>
  • The "span" formula doesn't seem to be working for me, I'm not sure why. I tried messing with it but couldn't get it to work. The "font" formula did work though! 
    Thank you very much!