Color Coding Calendars - Different Colors for Different Calendars, but from the same sheets?

chlod24

Hello!

I have a workspace with a ton of different sheets that each represent a project timeline for a single client. We are creating different reports to pull together program/client level views for things like team PTO, client due dates, internal resourcing priorities, etc. We use the calendar view of our reports primarily.

So all of this comes from the same source sheets, but we're creating these different reports for specific use cases, and many of these reports we see together on a single dashboard.

How can we make it so that each calendar has its own color key? For example, on a master calendar view, we'd want to see the colors by project (so, by sheet). But on a resourcing calendar, we'd want to see the color by the Assigned To column.

I know the colors pull from the task bar in conditional formatting, but stuck on how we can apply different formats to different reports, from the same sheet?

Andrée Starå

Hi @chlod24

I hope you're well and safe!

The color can't change depending on which report it's shown in. It will always be the same for all.

Make sense?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!