Quote:
|
Originally Posted by 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.