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
10 years ago
When I add the word text into the first line I don't receive any errors but the field now shows on the calendar as

<b><font color = #00cc66>[Project][Activity]</font color></b>

And the font color hasn't changed.