Multi-Select Summary Colorization

Question

I currently have a relationship between 2 tables, Questions and Evaluations. In the Questions table, I have a basic formula text field called "Result":If([N/A], "N/A",[Not Compliant],"Not Compliant",[Compliant], "Compliant","TBD")I'm then summarizing these values up to the Questions table for a particular report as multi-select summaries:

This is what a portion of the report looks like:
My goal is to have the Not Compliant results show in red. I've tried to use a rich text field verses a text field for the "Result" and this does not seem to work. Anyone have any suggestions? Is this even possible? Thanks for any feedback!

------------------------------TM------------------------------

ToddMolino · Answer

I went a different direction and worked out a solution.------------------------------Todd------------------------------

Sign up

Login to the community