| How about using conditional formatting, this gives you up to 3 nested options for each result cell and for this exercise you would need to use two adjacent ones.
Type "correct" in the first one and "incorrect" in the second and format them both so the font is white i.e. they are invisible under normal view. Then set the conditional format for each result cell so that they refer to the input cell and if the condition is met it changes the font colour to become visible. You can use different colours for the displayed text if you want to.
If you were using it for a spelling test then you could set it up so that the answer text would only become visible if the input was correct (the two cells agree) and it actually displays the word itself next to the input but maybe in a colour.
Hope this makes sense and helps by all means PM me.
__________________
Keep Safe, Keep Diving
Kim |