I want to highlight the days in the calendar that match the days on the event list. Right now I'm using formula: =MATCH(B5,$AC$4:$AC$39,0), it applies to =$B$5:$X$37.
The problem is I can only highlight with one color. I want to use different colors for each location. (light green for...