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