comparing values in named ranges

Hello I have 2 named ranges I want the values in named range 2 to be compared against the values in named range 1 and if they match change the background colour of that cell or highlight the cell in named range 1.

I have tried various versions of this code below, but have run into errors

Please Login or Register  to view this content.

Named range 1 = C3:G34
Named range 2 = N6:R6 1 row

Thank you for any help provided

Hi UltimateNeo,

hope this helps

Please Login or Register  to view this content.

Grtz

Try such combination:

Please Login or Register  to view this content.