Say i have 2 files. Both are identical in format. one is created on Monday, the other is created on Thursday. Is there an option in Excel that will automatically compare the Monday spreadsheet with the Thursday spreadsheet and highlight changes? Like, for example, Cell B15 on Monday gives a date of 01/04/04, and Cell B16 showes In Progress... and on Thursday it shows Cells B15 as 1/08/04, and B16 as Complete...it will highlight those.