Have had a good look at the links given & whilst they have opened me up to understanding a bit about conditional formatting their not really enabling me to achieve what I wish.

What I wished to achieve was almost there with the sample martinwilson uploaded. But as I said I couldn't copy that into my spreadsheet...

Basically I need to be able to highlight postcodes that show up on my regular weekly worksheet that match those that are listed on one of the worksheets.

Any more ideas anyone how to achieve this?