Answer Sheet

johnnyg00 · ‎May 19 2020

trying to make an answer sheet for 1000 question study guide i want to be able to input answer in column A and if correct check mark in B if incorrect X in B answers are a,b,c,d,e,f

bhushan_z · ‎May 19 2020

@johnnyg00 use attached file.
You need to update cells in "Yellow", rest is auto calculated

johnnyg00 · ‎May 20 2020

that's i awesome thank you but how do i do it so that they don't see the correct answer until they input answer in B column

bhushan_z · ‎May 20 2020

@johnnyg00 okay, I have moved correct answers to sheet 2.
Once you update Correct Answers, make that sheet 'Very Hidden' so that users can't see it.

HOW TO MAKE SHEET VERY HIDDEN:

refer to title "Make a worksheet very hidden by changing its Visible property"

Note: This is not my blog, it's just for reference.