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
Patrick, thanks for this solution. Two questions:
1. On my calendar the event displays with extraneous lines above and below the "Label" field: can these be eliminated?
2. Is there a way to make the "Label" field span multiple days?
Many thanks for the technique. Plenty of applications for this method.