compare two sets of rows in same sheet and highlight rows where duplicates exist.

[imran1059]

Hi Everone,

I need to compare two sets of rows in same sheet and highlight rows where duplicates exist. I know about conditional formatting highlight duplicates but thats not giving me the desired output as I have duplicates in each set of row as well. I need formula/macro to ignore the duplicates inside the ranges and compare with separate range and highlight if duplicate exists.


Thanks,
Imran.

 

[Kaper]

Build your conditional formatting rule around COUNTIF function.

 

[imran1059]

yup ...... I did it by match function in conditional formatting and it worked as desired.

Thanks.