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
RachelMiller's avatar
RachelMiller
Qrew Cadet
11 years ago
It does seem strange.  Below is what I have now and there's no change when I updated the line to <font color=red> with no spaces.  Is there anything else you can see that might be the issue?  I even tried creating a new calendar.  Thanks for all of your time!

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

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