Coloring a field
Hi, a few years ago, I built a bunch of formula fields that would display the text of another field with various colored backgrounds, using a Case() formula in a rich text formula field. For the...
Forum Discussion
You also need to close your <div>'s see bold and underlined > closures below:
Case([Overall compliance status],
"Fully compliant","<div style='background-color:#9EFFAF;'>"&[Overall compliance status]&"</div>",
"Not fully compliant","<div style='background-color:yellow;'>"&[Overall compliance status]&"</div>",