Display graphic to website based on excel worksheet data
I am needing some code on how to display a certain image based on what data is filled in on a worksheet. What I want is I have basically a red dot, yellow dot and green dot small graphic that I want to use and on the website will be a table with a name in one cell and in the cell right next it I want to depending on the spreadsheet populate it with one of those images. Lets say Steve has 4 papers due and 1 turned in on his sheet will be a column for due papers and a column for turned in papers and then a pecent complete. well I want to use the number in percent complete to determin what color gife to use on the website. If less that 40 I use red between 41 and 60 yellow and 61-100 green. Does this make sense? I would love to have this done automatically as right now I manually change the colors based on going to look at the spreadsheet and then editing the webpage.
ASPMicrosoft ExcelWeb Development
8/22/2022 - Mon
Your help has saved me hundreds of hours of internet surfing.