View Single Post

j4mes_bond25 · 12-21-2005, 10:35 PM

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.

12-21-2005, 10:35 PM	#1 (permalink)
j4mes_bond25 Bronze Member Join Date: Jun 2005 Location: Non-exotic city of Leicester from the Land of Hope & Glory Age: 28 Posts: 49	Microsoft Excel ??? 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.