Comparing two sheets and highlight unmatched data

Hi Patel,

Thanks for your Prompt response. Your code is absolutely perfect and the only requirement here is, some datas are showing as unmatched due to spaces in cell. would it be possible to code as if it needs to ignore the spaces and formats... Please advice...


Thanks,
Vignesh