Preventing Duplication

I

irresistible007

Well I think it shouldn't be a big prob but the thing is that i don
know the solution...

below is the example of sheet:

...........*A......................... B....................C*
*1*.....Customer...........Product............Order #
*2*.....ABC Co..............MS Excel...........99004
*3*.....DEF Co...............MS Word...........99001
*4*.....GHI Co...............MS Access.........99003
...
...
*15*.....JKL Co..............MS Excel............99005

The thing is that Col C is containing order no. unsorted and ar
manually inserted because of which the risk of Duplications come int
play.

Now lets say I entered the order no. 99003 (which is also in C4) i
Cell C9 by mistake.

Is it possible that Excel can change color of contents of both cel
i.e. C4 and C9 to Red ?

Or

Is it possible to show the repeated entry in cell C16 ?

Or

Is it possible to get alert pop-up or something alerting if i am tryin
to enter the no which is already registered
 
B

Biff

Hi!

You can do all of those things but this is your best solution:
Is it possible to get alert pop-up or something alerting if i am trying
to enter the no which is already registered?
Click to expand...

Select the range of cells in question. Assume that is C1:C15

Goto Data>Validation
In the Allow drop down select CUSTOM
In the Formula box enter:

=COUNTIF(C$1:C$15,C1)<=1

You can create a custom message that appears or just use the default. Click
the ERROR ALERT tab and fill in the message if you want to use your own.

Biff

"irresistible007" <[email protected]>
wrote in message
 
Top