Excel problemo

[jollyjayne]

Is it possible to have it so that if

1 / a double key is entered or
2 / info is being overwritten in a cell which already contains info

so that it brings up an warning similar to when you try to key in over protected areas etc ????

I am using Microsoft Office Excel 2003 if it helps.

[MarcusMel]

Info being overwritten you can not get warnings for - if your in the middle of overwriting you can recall the origional contents back with the escape key.

For double entries you can make a column to check that it has not happend by sorting the entries and then having a column of =if(A2=A1,1,0) and sum it. If the sum of that column is greater than 0 then there is a repeat entry.

[jollyjayne]

Many Thanks MM