Highlight cells which have no dependents

[Ali-imran]

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.

[Bob Phillips]

Create a named range on sheet2 covering A, called say sheet2Data.

Use conditional formatting on Sheet 1 with a formula of

=NOT(SIGN(COUNTIF(sheet2Data,A1)))