kevinmcilroy
New Member
- Joined
- Jun 8, 2011
- Messages
- 26
I have multiple non adjacent columns where i want to highlight when a duplicate occurs in one of the preceding columns.
The columns are filled in A to I, so therefore after all entries are entered into A i need any duplicate entries entered into C to be highlighted. Then any entries in A or C if duplicated in E highlighted, entries in A, C or E entered into G highlighted and so on.
Basically the 20 entered in C would be highlighted because its also in A, in E the 34 would be highlighted as its also in A and the 55 highlighted because its in C
<tbody>
</tbody>
The columns are filled in A to I, so therefore after all entries are entered into A i need any duplicate entries entered into C to be highlighted. Then any entries in A or C if duplicated in E highlighted, entries in A, C or E entered into G highlighted and so on.
Basically the 20 entered in C would be highlighted because its also in A, in E the 34 would be highlighted as its also in A and the 55 highlighted because its in C
A | B | C | D | E | F | G | H | I | |
1 | 34 | 20 | 87 | 12 | 56 | ||||
2 | 20 | 33 | 85 | 13 | 47 | ||||
3 | 56 | 11 | 34 | 14 | 39 | ||||
4 | 78 | 55 | 80 | 15 | 28 | ||||
5 | 23 | 99 | 55 | 78 | 12 | ||||
6 | 12 | 39 | 10 | 14 | 33 | ||||
7 | 13 | 45 | 30 | 66 | 77 |
<tbody>
</tbody>