Hello,
I have the next conditional formatting in the range A4:A16
=COUNTIF(B$4:B$16,A4)>0
(that identify any matches between columns A and B)
The problem I have, is that I need check one match by instance.
My problem with number 3.
I need the result of column D.
Or, if I have two instances of 3, I need the result of column G.
If I would have 3 instances of 3 or another number, the conditional formatting should identify the same instances of that number in the adjacent column.
rgds,
Arnolf
I have the next conditional formatting in the range A4:A16
=COUNTIF(B$4:B$16,A4)>0
(that identify any matches between columns A and B)
The problem I have, is that I need check one match by instance.
My problem with number 3.
I need the result of column D.
Or, if I have two instances of 3, I need the result of column G.
If I would have 3 instances of 3 or another number, the conditional formatting should identify the same instances of that number in the adjacent column.
rgds,
Arnolf
cformat.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | ||||||||||
2 | ||||||||||
3 | ||||||||||
4 | 9 | 1 | 9 | 1 | 9 | 1 | ||||
5 | 8 | 2 | 8 | 2 | 8 | 2 | ||||
6 | 1 | 3 | 1 | 3 | 1 | 3 | ||||
7 | 7 | 7 | 7 | 3 | ||||||
8 | 2 | 2 | 2 | |||||||
9 | 3 | 3 | 3 | |||||||
10 | 3 | 3 | 3 | |||||||
11 | 3 | 3 | 3 | |||||||
12 | 4 | 4 | 4 | |||||||
13 | 5 | 5 | 5 | |||||||
14 | 6 | 6 | 6 | |||||||
15 | ||||||||||
16 | ||||||||||
17 | ||||||||||
Sheet5 |