How can I make my calendar reflect the color of a data selection?

lindsay_lee

Hi!

I am making a calendar that will include multiple locations that will then be put on our company webpage so all global employees can see what is going on at any other location. People from different offices will be able to fill out the form and it will auto update on the webpage. I have a dropdown with the different locations that I want to color coordinate on the calendar that can be selected as forms are filled out

My question is: Is there a way to set up the sheet where people fill in a location and the calendar will automatically updated to reflect the color of that location? For example, when someone selects San Jose, it will be purple, when someone selects Albuquerque it will be yellow and so on...

Paul Newcome

You would use conditional formatting for that and update the Task Bar color.