James Halliburton
asked on
Microsoft Excel Dropdown Menu Creation
I've created several multiple choice questions in excel. Each question has a dropdown menu with 4 choices each.
Is there a way I can set this up so when a user selects the wrong answer they are alerted?
Is there a way I can set this up so points are accrued for each correct answer?
Is there a way I can set this up so when a user selects the wrong answer they are alerted?
Is there a way I can set this up so points are accrued for each correct answer?
ASKER
Thank you but I need more detail on how to set this up. For example, what would I do to have correct answers give a green background and incorrect answers give a red background?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much.
Correct answer could be highlighted with green background, wrong by red (unfortunately manual work for each answer). Each correct answer could have points which can be counted by formula
sample.xlsx