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