Conditional formatting those that match a list.

Thanks for looking at my problem,

As a quick example i could have a list of all UK towns, and then a sublist of uk towns in the same spreadsheet. I want to be able to identify the sublist by conditional formatting.

My question is how do i identify these using the conditional formatting by formula. (the list is extensive enough that i would want to select them all at once. I believe this should simply be a task of pointing me in the direction of the correct function.

Thanks for the help

Alan

You could use ISNUMBER(MATCH()) or COUNTIF() for the CF formula.
Provide more details for more specific solution

A quick example.

Cheers cutter, ill try one of these.

Worked" cheers cutter rep added!

You're welcome. Thanks for the 'star tap'.