I am trying to compare 2 worksheets in a large workbook. One sheet is named
1st Proposed HMIs. The other is named 2nd Proposed HMIs. Both spreadsheets
are exactly the same. I would like to compare the 2nd sheet with the 1st
sheet and have Excel highlight or shade any cell that has changed or
different data in the 2nd sheet. Any ideas? Thanks!