hi
i have a worksheet that contains list of questions in rows
i then have three columns called OK, Not OK and N/A
the user must select one of these cells(in line with the question)
Whati want to do is
if the user selects Not ok and realises he/she has made a mistake, if
the user then selects ok or N/A it clears the contents of Not ok Cell
and put X in relevent cell.

can anyone help with this

thanks

kevin