Hi John,

Follow me through:

Select D4:D250
With the range still selected, select Format Conditional Formatting
Formula Is
then type in:
=COUNTIF($D$4:$D$250,$D4)1
then select the highlighting colour that you want.

I then only get highlighted cell when I have duplictes.

Post back if you still can't get it to work.


--
HTH

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


with @tiscali.co.uk


"John" wrote in message
...
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.