I have a workbook that I am using to manage my travel with. During the year
I will be in a number of different cities for various periods of time. I am
logging itineraries into one sheet and manually updating another sheet within
the same workbook that displays my schedule in calendar format.

What I would like to be able to do is format the cells in the calendar view
based on my date entries & locations I will be in on those dates. For
example, if I am in Charlotte from 4/1 until 4/15 I'd like the corresponding
calendar cells to have a red pattern color, and if the city were lets say
Savannah it would have green pattern color instead.

Two items here then:

1. Setting conditional format based on city in my itinerary.
2. Cell comparison based on time period (arrive/depart)

Is this possible, or should I continue to update manually?

Thanks so much!