There are multiple ways to compare two columns in ... Clear Rules > Clear Rules from Entire Sheet. List Similar Values In A Different Column With VLOOKUP While Excel's conditional formatting ...