One other play to try

Select the entire range, eg select A1:J10 (A1 active),
then apply CF using Formula Is:
=AND(A1"",COUNTIF($A$1:$J$10,A1)1)
Format to taste ok out
Adapt the range to suit

If above works, high-five it here, click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"GVPro" wrote:
I have series of serial numbers in five non-adjacent columns.
Ineed to find, and, if possible, highlight them.
I am using Excel 2003 at work and 2007 at home.

EX:
A B C D E F G H
I J

1 31686 ....... 21213 ....... 37801 ....... 55555 ....... 78613
.......
2 37814 ....... 80081 ....... 67766 ....... 54455 ....... 84400
.......
3 55555 ....... 60550 ....... 41223 ....... 10002 ....... 27177
.......
4 43477 ....... 77772 ....... 43434 ....... 94867 ....... 29525
.......
5 69362 ....... 24543 ....... 55555 ....... 99323 ....... 63122
.......