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?

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

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

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

below is the example of sheet:

..........*A......................... B....................C*
*1*.....Customer...........Product............Orde r #
*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 are
manually inserted because of which the risk of Duplications come into
play.

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

Is it possible that Excel can change color of contents of both cell
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 trying
to enter the no which is already registered?


--
irresistible007


------------------------------------------------------------------------
irresistible007's Profile: http://www.hightechtalks.com/m63
View this thread: http://www.hightechtalks.com/t2272756