Hi! I import data each month into spreadsheets. I would like to set up each monthly spreadsheet so that if a name changed from last month's spreadsheet it gets shaded a certain color. I tried conditional formating but it won't let me refer to another .xls file, and I'm a novice with macros. Thanks in advance for any replies.