My problem: I have a very large list of items that I had to break into two spreadsheets. The first spreadsheet (spreadsheet #1) has 55,931 lines and three columns the second one (spreadsheet #2) has 64,837 lines and three columns. I have a third sheet (spreadsheet #3) that consists of 1160 lines and one column. I would like to identify everytime an item in sheet #3 appears in Column B of spreadsheets 1 and 2 by having them turn the background yellow. For instance if spreadsheet 3 was a list of automobiles and spreadsheets 1 and 2 was a list of all vehicles I would like to identify everytime an automobile is located in spreadsheets 1 and 2 that appears on sheet 3 by turning the background yellow.