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
ArchiveUser's avatar
ArchiveUser
Qrew Captain
10 years ago
Thanks - I'm currently using the below formula in a text-formula field that is looking at a separate field (Client). I'm not sure I completely follow what you're doing. Can you see a reason why the formula below would be including the extra lines?

If(
[Client]="ABC","<div style=\"color: #000000; background-color: #C0C0C0;\">ABC</div>",
[Client]="XYZ","<div style=\"color: #ffffff; background-color: #0000FF;\">XYZ</div>",
[Client]="123","<div style=\"color: #ffffff; background-color: #FF00FF;\">123</div>")