j4mes_bond25

Does anyone know, if I can set a validation in Excel in the way, that say, Row A already has data typed in it but when someone opens the file, they can't see the text of Row A (or a particular cell), but can type in it & IF only they type the same text which is already in there (i.e. within a cell, however, invisible to them) can they SEE the text, after they press Enter (bringing the squared cursor to the next cell).

If the typed information doesn't match with what's in that particular cell, then it should remain blank, so he/she would know that information typed is incorrect i.e. doesn't match with what's already in there.

jjsevdt

unless there's a way to do a macro you can't delete the contents of a cell because it doesn't match, but you you can hide A and do an IF statement to display True or False if B matches A

__________________
C2D E6420 @ 2.13GHz on AsRock 4CoreDual-VSTA
2GB DDR2 533
1 - 80GB | 1 - 60GB
BFG Nvidia 7600GS
Soundblaster Audigy

PSN: JjSeVdT
XBOX Live: JjSeVdT

j4mes_bond25

After doing search on Internet, data validation seems like a plausible option & I can hide the text simply by changing the text colour to white.

As you can see from the attachment, that I'm probably using the right command i.e. Data > Validation, however, all I could do is simply set the length of the text. So, if someone types in "drink" in the cell "drink coffee", that will show NO error, since the word "drink" in itself has 5 character of text length.

However, what I rather wanted was a way excel "identifies" the text within the cell in the way that if, it doesn't get typed the way it's in there i.e. if someone doesn't type the exact "drink coffee" then, it should show the error.