By joevn93 on Thursday, 16 December 2021
Posted in Excel
Replies 0
Likes 0
Views 3.1K
Votes 0
I have 5 criteria. Each criteria has 5 different buttons (different color) represent for each option with a certain score for each.

How to remain the color of a desired button and assign value to it when choosing, and in parallel the other buttons will change to the same color (grey for instance)? And at the same time, the comment cell will appear the describe text for the option that I chose

After choosing the option for all criteria, we will have the overall score below

Here is the mock-up for your reference: https://drive.google.com/file/d/11FvEGqGI2gd3PXTFiBQkORdXUKBnHbFh/view?usp=sharing
 
Thanks a lot in advance for your help.

Much appreciated.
View Full Post