COLORIZE FIELD
I need to colorize a new "Rich Text Formula Field" (formula is equal to another field) based on a status field. new field: [NEED EWO#] formula 1: [JOB NUMBER2] Then, I need the field to be red if...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendDo you want the words red or the background red?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
The words
------------------------------
Lynne8817 Lynne8817
------------------------------
------------------------------
Lynne8817 Lynne8817
------------------------------
- MarkShnier__Younew field: [NEED EWO#]
formula 1: [JOB NUMBER2]
Then, I need the field to be red
IF([EWO# STATUS]="GET EWO#","<font color=red>" & [field to be colorized], [field to be colorized])
.... but if the field to be colorized is numeric, then you will need to have
IF([EWO# STATUS]="GET EWO#","<font color=red>" & ToText([field to be colorized]), ToText([field to be colorized]))
i
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- I don't need to do an "and" or anything after the 1st line in the formula [JOB NUMBER2]?
------------------------------
Lynne8817 Lynne8817
------------------------------- the field that needs to be colorized is the new field [NEED EWO#]
I'm trying to combine the formulas
[NEED EWO#] is
[JOB NUMBER2]
IF([EWO# STATUS]="GET EWO#","<font color=red>")
------------------------------
Lynne8817 Lynne8817
------------------------------