Using a hyperlink to a Thumbs up if 100% is achieved. Or if not a thumbs down.

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

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are relatively new here, I shall do it for you this time only: https://www.mrexcel.com/board/thread...-down.1255981/)


There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.


Is your forum profile showing the Excel PRODUCT that you need this to work for?

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.