Hi There!

Just a quick one! Any help greatly appreciated. I have a list of place names in a column, several hundred of them, and I want to highlight specific place names a specific colour.

So the list looks like this:

Ancona
Barcelona
Bari
Belfast
Bilbao
Bremerhaven
Brest
Brindisi
Cadiz
Cagliari
Cannes
Cartagena
Catania
Cefalonia
Civitavecchia
Cobh
Constantza
Copenhagen
Corfu
Dublin
Elsinore
Flamm
Gibraltar
Goteborg
Gran Canaria
Greenock
Hamburg

And say I wanted to shade the cells containing the names shown below in red:

Copenhagen
Corfu
Dublin
Elsinore
Flamm
Gibraltar
Goteborg
Gran Canaria


Is there a way to tell excel to find any cell that matches any cell in that range and shade it red?

Many thanks,

Adam