j4mes_bond25
Baseband Member
- Messages
- 48
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.
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.