Hi All,

I’m looking to format one range of postcode data based on the values given ina range in another sheet. Im trying to match up businesses to postcodes, based on postcodes assigned to the businesses. See the screen shot below. In this example I am looking to highlight any postcodes in sheet 1, that are the same as the postcodes in sheet 2’s data set.

I’ve been searching for a conditional formatting formula but haven’t found any that work, please help!

​Hi All, I’m looking to format one range of postcode data based on the values given ina range in another sheet. Im trying to match up businesses to postcodes, based on postcodes assigned to the businesses. See the screen shot below. In this example I am looking to highlight any postcodes in sheet 1, that are the same as the postcodes in sheet 2’s data set. I’ve been searching for a conditional formatting formula but haven’t found any that work, please help!   Read More

​