-
Highlight cells which have no dependents
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules