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? ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendtry 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
------------------------------
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
------------------------------
I tried it and it does not like field 2020 Chronic Vs Acute Status.
------------------------------
ALEXIS DALY
------------------------------
------------------------------
ALEXIS DALY
------------------------------
- MarkShnier__YouYou 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
------------------------------- 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__YouJennifer
Can you copy and paste your actual code into the thread. 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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
