I have a text box on a report that pulls values from a table: Blue, Red, Green, Gold, Yellow, Purple, and White.
The report is supposed to have the background behind each word be that color. IF the data has the color Blue, then the background color behind that word should be Blue as well. I...