Is there a way to mass edit the color of an item in the calendar view of a sheet?
I'm creating a calendar with all the different tasks our leaders need to do each year. Is there a way for me to color coordinate so each task is the same color every month without going one by one? The screenshot below shows how you can do it for one item but that's too tedious. I've tried conditional formatting but that only works on the grid view and does not include the calendar view.