Hello! What I would like to do is on Sheet 1 have a list of questions in Column A & Answers in Column B, then for anything i type on sheet 1 in column A to be copied automatically to sheet 2 Column A. Then on sheet two column B will be blank and if the answer is wrong it changes the text red... Something like this opened for other opinions But I would like it to compare the answers ect. (basically sheet 1 is the answer sheet and sheet 2 is where you would type in the answers, trying to make a practice test for something) thank you!