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

9 Replies

Related Content

Color-coding a field returns field name

An API(?) button to copy fields from the form, to other fields

Color Coding Fields: Duration

Color row in calendar based on two user fields

Color coding based on Next Due Date field

Recent Discussions

When the Expiration Date is On or Before Today, Change the Contract Status to Expired

Empower Hour Tomorrow!

Rollup Help

New Forms Return and Cancel Buttons Glitch

How to handle error in Upload step in Pipeline