Using a hyperlink to a Thumbs up if 100% is achieved. Or if not a thumbs down.
Hi , I have created a progress chart where each week participants record a number in one cell and the next cell automatically converts that number to a percentage of the progress made, as in the mock up below:
Ben 0 0.0% 17 9.7% 128 72.7% 176 100.0%
Bob 57 32.4% 71 40.3% 96 54.5% 124 70.5%
Bill 1 0.6% 3 1.7% 74 42.0% 113 64.2%
Brad 0 0.0% 19 10.8% 42 23.9% 160 90.9%
Brian 130 73.9% 152 86.4% 176 100.0% 176 100.0%
I need to add some fun into this task so I�d like to add another cell that say �Click to check progress� Then only when the formular can see a 100% it will open a hyperlink to a small "Thumbs Up" icon on the page (so not to a new web page) and a message pops up with �Fantastic You Have Finished�. But if there is not a 100% in their row then when the cell is clicked, the hyperlink is to a Thumbs Down and a message �Your nearly there keep going�.
I have tried this but it is not even valid. Plus others and nothing works. =IF($D$11:$J$11="*100", HYPERLINK("#$$D$11:$J$11", "Click here to check progress"), "#"&$D$11:$J$11) But this not work or even has the link to a Thumbs Down . If anyone has had success with this could you help, it would be awesome.
Thanks
Moaman
Bookmarks