Thanks for reply, however I only need numbers 3 and 4 to be highlighted.

These or any other similar Numbers which are the same in the subject line
and 4 other rows.

Thanks for your response. If anyone could further this arguement it would be
appreciated.




"smandula" wrote in message
...
Is it possible to highlight recurrant items from a subject row to
five rows below? When activating any row. In Yellow both the subject
line and any one of the five comparable lines.In VBA.
For Instance

A B C D
1 11 12 13 14
2 1 2 3(y) 4(y) <---- subject line active
3 9 10 3(y) 33 -|
4 22 23 24 25 | comparables
5 6 7 4(y) 11 -|


With Thanks