I would like to set the font color to green, black or red based on a data extension. The data extension passes a text string such as:
"Status is active."
"Status will expire soon."
"Status is expired."
I want to look in the data extension for the word active, soon or expired and then set the corresponding color.