I have 4 columns of records in an excel file with almost thousand rows of data. I need to show highlights of similar records across two columns such as System1, Record1 and System2,Record2. For example in the attached file, I need result highlighted in color for similar records such as db2 and abcd for both system1 and system2 across 4 columns. I could do using vlookup for 2 column comparison but here if system1 and Record1 values match with system2 and record2 values, I want it highlighted. Is there a simpler solution using built in conditional formatting instead of vba?
Thanks for your help in advance.