Hi Folks,
Need ideas for this one. I have a workbook with two sheets of data and want to know which rows on Sheet1: 1) Identically match, 2) Have matching cells, 3)Have no match on Sheet 2.
For Sheet1 Rows that have an identical match on Sheet2:
- Highlight Green
- Take ID# from ColumnA:Sheet1:Row# and attach it to matching row on Sheet2
For Sheet1 Rows that do not have an identical match but have a row that has matching cells (At least 2)
- Highlight Matching Cells Blue
- Highlight Nonmatching Cells Yellow
- Take ID# from ColumnA:Sheet1:Row# and attach it to matching row on Sheet2
For Sheet1 Rows that do not have a match at all
- Highlight Red
I have attached an example with desired final state.
Really appreciate ANY ideas or thoughts.
Thank you very much for your help!
Bookmarks