Conditional formating, mutiple variables, mutiple sheets

Hi,

Can you please help with the below.

I have two sheets, Combined and Priority, which both have columns called Ref and Pf. I would like the code to highlight all the rows on the Combined! sheet that have column values that appear on the priority sheet.

As the priority sheet changes the existing variable LastRowWithData can be used for the last row when defining the range. The columns (B & C on Combined and A & B on Priority) do not change nor does the first row that data appears in.

In the attached there are three sheets, Combined, Priority and End Result which is how I wish Combined to look after the code has been run.

Thanks in advance