I am trying to get a formula or macro to read if a cell in range of workbook 1 matches a cell in range in workbook 2, then highlight row in workbook 2.
So if Cell A:A in workbook 1 matches cell in D:D in workbook 2 then I want the cell (or row if possible) to highlight in workbook 2.
I've tried this =ISNUMBER(MATCH(B:B, 'wkbk1'!B:B, 0)) but it just highlighted the whole column. I've tried conditional formating options but it requires me to do it per cell and I need a range with over 10,000 rows. Any advice would be great. I'm thinking of creating a macro that also opens the second workbook but isn't necessary.
So if Cell A:A in workbook 1 matches cell in D:D in workbook 2 then I want the cell (or row if possible) to highlight in workbook 2.
I've tried this =ISNUMBER(MATCH(B:B, 'wkbk1'!B:B, 0)) but it just highlighted the whole column. I've tried conditional formating options but it requires me to do it per cell and I need a range with over 10,000 rows. Any advice would be great. I'm thinking of creating a macro that also opens the second workbook but isn't necessary.