Hi Sandy

Thanks for the response. Sadly, Im not as good as I thought and can't make
this formula work in conditioning formatting? I'm using column D in the
spreadsheet where I am trying to prevent two of the same number being
entered. Actual cells are D4 to D250 after column headers etc. Currently,
others headers turn red and bold as soon as any entry is made in column D4
downwards, the conditioning formatting applies but does not indicate a
dublicate entry??

Any further thoughts please???

"Sandy Mann" wrote:

John,

Try Conditional Formatting using a formula.. You can use it to highlight
duplicates in (say) Column A with the formula:

=COUNTIF($A:$A,$A1)1

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"John" wrote in message
...
I am trying to prepare a new sales order management spreadsheet for my
Warehouse staff to record orders reaching them for picking and packing.
Nothing fancy but I have a definiative requirement in stopping orders of a
five digit format from being entered twice unless it is a back-fill order
where we can have a forward slash with a number or letter reference added
too.