Hi Butman,
Sorry, I have been MIA over the weekend!
Daddylonglegs pretty much outlined what I was suggesting. I have attached a sample of how this would work. You add the city and the region to the 'region' tab, and the conditional formatting on the main sheet will adjust accordingly.
Bookmarks