number repetitions highlighted

hi. i am somewhat new to excel. i have attached an excel table... a work sheet to develop numbers. i am almost completed it and i am trying now to get repeated numbers from all categories to be highlighted even if they are not in the same sequence that is eg.4695 appearing as 5964 or 6954. etc. and then i need it to appear on a seperate sheet as the highleted numbers... is there a possible way i can do such. thnxs