Color Fields

Question

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?&lt;font color=red&gt;" &amp; [2020 Chronic Vs Acute Status] &amp; "&lt;/font color&gt;" = YesI'm looking to have the CMS-HCC V22? in red if it says no and green if it says yes------------------------------Alexis------------------------------

markshnier__you · Answer

try thisIF([2020 Chronic Vs Acute Status]="Yes",&lt;font color=red&gt;" &amp; [2020 Chronic Vs Acute Status] &amp; "&lt;/font color&gt;",[2020 Chronic Vs Acute Status]="No",&lt;font color=green&gt;" &amp; [2020 Chronic Vs Acute Status] &amp; "&lt;/font color&gt;",&nbsp;[2020 Chronic Vs Acute Status])------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

alexisdaly · Answer

I tried it and it does not like field&nbsp;2020 Chronic Vs Acute Status.&nbsp;
Should I be in the actual field? The Field is originally supposed to multiple choice but I changed it to rich text------------------------------ALEXIS DALY------------------------------

markshnier__you · Answer

You need to have to have two different fields.

One will be the Multiple choice field wiht the choices of Yes and No.

The other field will be a Rich text formula field which will add color formatting to those words. The editing will be done on the plain multiple choice field. So you will use the pretty fields on View mode on the form and in reports.

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

jenniferpaschal · Answer

Hi Mark,I am trying to do something similar to one of my fields. I want to color the field in reports but then also make it show text for "green" "yellow" "red" so that the data is consumable via export. I currently have a formula - text field with the following formula

that sets the value = to "Green" "Yellow" "Red" or blank based on certain conditions. How could I go about creating a formula that would both set the text value and color the field? What the value of a formula like that look when exporting data to Excel spreadsheet?------------------------------Thanks in advance,Jennifer Paschal------------------------------

markshnier__you · Answer

JenniferCan you copy and paste your actual code into the thread.&nbsp; I can't really read it and its not copy pastable for me to edit when it's a screen shot image.Mark------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Color Fields

Related Content

Color Code Date Field based on Formula

Color Coding based on field value

Snapshot Fields

Proxy fields

Find and Replace Field Values