Hi,

I am looking to check that two columns in excel match. I can use conditional formatting to check each row at a time but when I drag it down to cover multiple rows it is searching all the cells for duplicates not just each individual row. I can format each row individually but this may take a very long time. Is there another way of doing this? Any help would be greatly appreciated.