Thanks for the swift reply ! this works very well !

However, what if data in column F, H and J are in another sheet like Sheet 2. What modifications to the code that I need to make so that it compares between Column A in sheet 1 and F, H and J in sheet 2 ? I could only understand some of the codes, unsure if what I've just asked has already been written in the code above.