Hi,
Macro will be placed in macro.xlsm & book1.xlsx & Book2.xlsx are located at different place so the path of of both the files should be hardcoded in the macro
If cells in column A of sheet1 of book2.xlsx matches with cells of column A of book1.xlsx then dont do anything & If it doesnt matches then remove all the highlighted colour in that row of book2.xlsx
(May be it has highlighted colour or it may not have highlighted colour but if it doesn't matches then if highlighted colour are present then remove the highlighted colour, do not clear the data or change the data )
highlighted colour may be anywhere in that row or it will not be there
Thnx
Bookmarks