I’ve looked online for tutorials, but can’t find any that pertain to what I’m trying to do. I’m hoping that one of you can help. I’m creating a list of Mental Health Blogs. Column A contains the name of the website. Column B lists each websites URL. My first mission is to hide column B and somehow link column A to the URL so that clicking the title will take the viewer to the selected website. Is this possible?
In Column C I indicate weather or not the website is currently active. Meaning is it being updated? I want to input “yes” for active, and “no” for inactive or the numbers “3”, “6”, “9” to indicate the number of months since the last update. However, I also want this column to be hidden and the color of the font used in column A to change dependent on the information I input in this column. Again, is this possible?
Lastly, I’m sorting the websites based on what mental illness the site focuses on in Column D. Would there be a way to have some sort of drop down menu? For instance, I’d like to be able to select “depression,” then have only the websites that focus on depression show up in a list.
I’d be more than appreciative if anyone can help me with any of this! Thanks in advance for your time.