So, I have two spreadsheets that I tried to use conditional formatting to highlight duplicates, but failed.
Data from Spreadsheet A has multiple columns but I need to compare only: Column A - order # Column C - count Column D - date
Spreadsheet B also has many columns, but I need to compare: Column A - order # Column B - count Column E - date
I need to highlight column A in the rows on both spreadsheets when the data across the row is identical.
So if data in A,C D of whatever row is found to be identical in A,B,C of any row, then highlight A of that row on both sheets.
In this example, row 6 and 14 have different dates and 7 and 15 have different quantities so they wouldn't be flagged.
For ease of input I used only one spreadsheet, but this data is on two different spreadsheets.
Example.JPG
Bookmarks