Forum Discussion
Conditional Formatting based on two ranges of data (postcodes)
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 bu...
Try to add this on the formulation of conditional formatting of the first cell of Sheet1:
=ISNUMBER(XMATCH(A1;Sheet2!$A$1:$A$5))
Assuming A1 is the first cell on Sheet1 and A1:A5 is the full range of Sheet2. Please note the absolute/relative referenes.
Then, select the "Format Painter" on the Home tab of the ribbon and copy the format of this first cell to the rest of the cells in Sheet1.
