Hi All, I've spent the past hour or so trying to find a answer to my
problem. Of the responses I have found I just don't how to apply them in the
worksheet or VB.

I have a spreadsheet and via a list users have the option of selecting 3
words, fail, success, other. What I want is when the word 'fail' or 'other'
is selected and the comment field is not populated, I want it to force the
user to make an entry. Once that entry has been completed they can move to
the next field (across).

a b c d e f g h
1 date event action comment event action comment
2 17/06 weekly success weekly fail
3 18/06 monthly fail monthly success
19/06 quarterly other quarterly fail

I also don't know a great deal about VB so would need to be gently guided.
ie have no idea where to paste to make a formula work.

TIA
AussieBec