Forum Discussion

RachelMiller's avatar
RachelMiller
Qrew Cadet
11 years ago

How do I add color coding to a calendar report based on text?

I have a calendar report that I need to add color coding to. I'm looking for a simple formula that says: If [Activity] = Build, make bar green If [Activity] = Go-Live, make bar red If [Activity] ...
Formulas and functions
reports and charts
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
11 years ago
Did you include the first line in the formula like this?


var ProjectActivity = List(" - ",[Project],[Activity]);

If([Activity]="Build", "<b><font color = #00cc66>" & $ProjectActivity & "</font color></b>", $ProjectActivity)