have two sheets like sheet1 and sheet2. In sheet1 data is linked to sheet2 in C and D column. In other words data is going to sheet2 in C and D column from sheet1.

I want macro colour cells in sheet1 which is not going to sheet2 in C and D column.

For example:

Sheet1
A
12
89
56
78
99
33

Sheet2
A B C D
0 0 0 12
0 0 89 0
0 0 0 78
0 0 33 0

Macro colour cell A3 and A6 because figure 56 and 99 not going to sheet2 in C and D column specifically.