I have created a drop down list with rankings (1-5) and would like for each ranking to have a different comment or input message associated with it. The idea being when you click or huffer over a 1, you see that definition for a one ranking and so on for rankings 2-5. I am an excel novice, but I have attached my sad attempts. You will see I just added the definitions to the cell to be chosen from the drop down list for the first few rows and then you will see in the last 3 rows I just have the comment, but the comment in there is only relevant for that specific number.
Thanks in advance for any help you can provide.
Thanks in advance for any help you can provide.