Microsoft Excel ???

[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

 

[j4mes_bond25]

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

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.