highlight duplicate entries

I have to keep track of load ticket numbers for our trucking company. I have
it set up so they are all in one column. Is there a way I can set it up to
warn about duplicate entries? Version I use is MS Office 2002. Any help would
be much appreciated!
Thanks. Linda

Assume your range is A1:A100...

<Format><Conditional Formatting...>
From the drop down box choose "Formula Is"
Enter this formula: =COUNTIF($A$1:$A$100,A1)>1
Choose a format (e.g. background color, text color) to display for duplicates
Select "OK"
Copy the formatting of this cell down to the end of your range

Note: Change the reference of A1:A100 to fit your data.
--
Regards,
Dave


"Baylee" wrote:

> I have to keep track of load ticket numbers for our trucking company. I have
> it set up so they are all in one column. Is there a way I can set it up to
> warn about duplicate entries? Version I use is MS Office 2002. Any help would
> be much appreciated!
> Thanks. Linda

Hello there Linda,

I would recommend you checking out brettdj's Dupicate Master ...

http://members.iinet.net.au/~brettdj/

HTH


--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.


"Baylee" <Baylee@discussions.microsoft.com> wrote in message
news:3F24D81A-AE12-4579-A3A1-C523D83E0F78@microsoft.com...
>I have to keep track of load ticket numbers for our trucking company. I
>have
> it set up so they are all in one column. Is there a way I can set it up to
> warn about duplicate entries? Version I use is MS Office 2002. Any help
> would
> be much appreciated!
> Thanks. Linda