COLORIZE FIELD

Question

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 [EWO# STATUS]="GET EWO#"

------------------------------
Lynne8817 Lynne8817
------------------------------

markshnier__you · Answer

Do 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
------------------------------

buildpro · Answer

The words------------------------------Lynne8817 Lynne8817------------------------------

markshnier__you · Answer

new field: [NEED EWO#]formula 1: [JOB NUMBER2]Then, I need the field to be red IF([EWO# STATUS]="GET EWO#","&lt;font color=red&gt;" &amp; [field to be colorized], [field to be colorized]).... but if the field to be colorized is numeric, then you will need to haveIF([EWO# STATUS]="GET EWO#","&lt;font color=red&gt;" &amp; ToText([field to be colorized]), ToText([field to be colorized]))i------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

buildpro · Answer

I don't need to do an "and" or anything after the 1st line in the formula&nbsp;[JOB NUMBER2]?------------------------------Lynne8817 Lynne8817------------------------------

buildpro · Answer

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#","&lt;font color=red&gt;")------------------------------Lynne8817 Lynne8817------------------------------

Forum Discussion

COLORIZE FIELD

Related Content

Color Code Date Field based on Formula

Find and Replace Field Values

Color-coding a field returns field name

Consolidate Field Types

Formula Date Field