jrussell121
New Member
- Joined
- Apr 20, 2002
- Messages
- 1
A B C D E F
1 1 2 3 4 5 6
2 4 5 6 7 8 9
3 1 2 7 8 33 34
4
5
6
7
8
9
10 1 2 7 8 33 50
11 1 2 51 52 53 54
Please could any one help the problem i have is to highlight the background colour of the cells A1:F1,A3:F3 if the number appears in the cells A10:F10,A11:F11 in the example above A1,A3,B1,B3,C3,D2,D3,E2,E3 would be coloured.
That is A10:F10,A11:F11 is being treated as a set and every occurance of a number in the set is then colured in the cells A1:F1,A3:F3
I think that i need a macro to achieve this
regards
john russell
1 1 2 3 4 5 6
2 4 5 6 7 8 9
3 1 2 7 8 33 34
4
5
6
7
8
9
10 1 2 7 8 33 50
11 1 2 51 52 53 54
Please could any one help the problem i have is to highlight the background colour of the cells A1:F1,A3:F3 if the number appears in the cells A10:F10,A11:F11 in the example above A1,A3,B1,B3,C3,D2,D3,E2,E3 would be coloured.
That is A10:F10,A11:F11 is being treated as a set and every occurance of a number in the set is then colured in the cells A1:F1,A3:F3
I think that i need a macro to achieve this
regards
john russell