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 don't need to repeat the reference to your field in the Case(). Just at the very beginning and then check for expected responses
Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
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>",
"")Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
