Ali-imran
07-15-2009, 03:22 AM
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.
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.