I have built a spread sheet (excel 2000) where I enter drawing numbers and I already have thousands of numbers in it. I would like to know when I duplicate a number in a column, I do not want to use a data base. I would like the cell to turn a different color when there is a duplication. There may even be circumstances where the number is duplicated 4 or 5 times, I would like them all to turn a different color. Can anyone help me with this.
thanx
thanx