Hi,
I have extensive experience with writing macros for Excel as I have used it for research and also studied it at faculty. I will keep the files format .xls. I will gray out the cells in file 2 as you requested, for values that exist in file 1. I will deliver in 5 days.
Best regards,
Bogdan