Bennie

select columns A to G. Now Select Format | Conditional formatting... and
input:

Formula is: =COUNTIF($A:$G,E4)1

Pick a suitable format, perhaps a yellow background and press OK

You might be better selecting a limited range rather than all of columns A
to G as this could be very slow.

Perhaps Formula is: =COUNTIF($A1:$G1000,E4)1

Regards

Trevor


"Bennie" wrote in message
...
Hello! I have a very large spreadsheet and I need to search it for a
duplicate invoice numbers. I am entering invoice numbers in the first
seven
columns. Can you tell me the easiest way to check the first seven columns
for for duplicate numbers? Thanks for your help!!!