View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael Ubezzi
 
Posts: n/a
Default Comparing worksheets in Excel and highlighting changes

I receive an Excel 2003 workbook with 3 worksheets every 2 weeks. I want to
compare each of the three worksheets in the new workbook against the same
worksheets in the previous workbook. I would like the cells highlighted in
the new workbook that differ from the previous workbook for the same
worksheet. If there is a new row, highlight the new row.