Skip to main content
Question

Color Fields

Good Morning,

I am trying to color fields red and green. I have rich text options but it keeps giving me errors.
I've tried many different formulas. Can someone guide me in the correct direction?

<font color=red>" & [2020 Chronic Vs Acute Status] & "</font color>" = Yes

I'm looking to have the CMS-HCC V22? in red if it says no and green if it says yes

------------------------------
Alexis
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
try this

IF(
[2020 Chronic Vs Acute Status]="Yes",
<font color=red>" & [2020 Chronic Vs Acute Status] & "</font color>",
[2020 Chronic Vs Acute Status]="No",
<font color=green>" & [2020 Chronic Vs Acute Status] & "</font color>", [2020 Chronic Vs Acute Status])



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement