Hi all,

Sorry for late reply. Didn't have the chance to log back on since then.

Thanks a lot for your help. I tried to implement those codes but I couldn't make them work. As recommended I attached a file so that it is easier to visualize the problem.

File_Forum.jpg

To answer p45cal yes, it has to be an exact match. The cell can contain only one value i.e only USA or only Germany. If so then, I want excel to cancel the entire row.

Thanks again!