+ Reply to Thread
Results 1 to 2 of 2

Hyperlinks to other sheets to change color if change made

  1. #1
    Registered User
    Join Date
    07-25-2022
    Location
    Barcelona
    MS-Off Ver
    Windows 11
    Posts
    1

    Question Hyperlinks to other sheets to change color if change made

    Hi all!

    I'm very happy for my first post in this community.

    I have an idea for an excel file, but i'm not sure if it is feasible.
    I have an excel where in the first sheet there is a menu (with hyperlinks) where you can go in each different section of the document (in the different sheets there are all tables) (and also go back).
    My idea is the following:
    Whenever a person add a new row in one of the table, the corresponding cell in the first menu sheet change color; so if anyone open the document, can notice which section have been modified or not. Kinda like a notification system, so you don't have to manually check all the sheet to see if there is something new in the document.

    Hope i have explained myself well.

    Thanks in advance for the help
    Last edited by FDibbins; 07-26-2022 at 12:00 AM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Hyperlinks to other sheets to change color if change made

    Welcome to the forum

    1. You have explained yourself very well (at least, I think so).

    2. Per our forum rules, you need to title your thread with something that explains your problem (I have changed it for you - this time. Please be more specific next time )

    3. Based on what I think you are asking for, this will, I believe, require VBA (code) and cannot be done with formulas.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel keeps calculating - no idea why?
    By martmass in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 04-29-2021, 02:10 AM
  2. Idea for excel appliction
    By behedwin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-27-2017, 11:35 AM
  3. Help with Excel idea
    By prescotmunn in forum Excel General
    Replies: 1
    Last Post: 03-15-2016, 02:41 PM
  4. Excel...I had no idea...
    By lawlegge in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-20-2013, 08:33 PM
  5. Excel for noobs. No idea where to start...
    By dynastyss in forum The Water Cooler
    Replies: 4
    Last Post: 10-10-2012, 10:49 AM
  6. Beautiful Visualization Idea - Can excel do it?
    By saltcod in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-10-2008, 12:30 PM
  7. Replies: 0
    Last Post: 05-21-2006, 08:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1