Hello everyone,

I'm trying to make macros which will find and color particular cells which have the same value as cells in other sheet.

I have two different sheets - 1st one smaller (~500 rows with several columns) and 2nd sheet with ~60000 rows and more columns. I need to make a macros that will check if the cell value (ten digit number) in the 1st sheet is mentioned in 2nd sheet - if yes, the cell in the 1st sheet should be filled in red.

In the first sheet column with those ten digit numbers is C. In the 2nd sheet - B.

This macros should be triggered with some keyboard combination.

I tried using conditional formatting, but it doesn't work for me... Maybe you could help me?

Thanks!