PDA

View Full Version : [SOLVED] Highlight cells which have no dependents



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.

Bob Phillips
07-15-2009, 06:13 AM
Create a named range on sheet2 covering A:D, called say sheet2Data.

Use conditional formatting on Sheet 1 with a formula of


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