+ Reply to Thread
Results 1 to 9 of 9

Hyperlinks and conditional formatting

  1. #1
    Registered User
    Join Date
    12-04-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    4

    Hyperlinks and conditional formatting

    Hi

    My problem is that I want a hyperlinked cell to change colour and font when it is accessed. i'e. when the hyperlink is clicked, the destination cell in the same workbook changes colour so that it stands out on the sheet.

    I have around 140 hyperlinks accessing various cells in 9 worksheets.

    If you can help I would be most grateful.

    Regards
    lev

  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,186

    Re: Hyperlinks and conditional formatting

    Welcome to the forum. There are various options whizzing around depending on why you are trying to do this.
    Could you give a bit more information about how the spreadsheets are being used.


    click on the * Add Reputation if this was useful or entertaining.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,004

    Re: Hyperlinks and conditional formatting

    Quote Originally Posted by Lev1948 View Post
    Hi

    My problem is that I want a hyperlinked cell to change colour and font when it is accessed. i'e. when the hyperlink is clicked, the destination cell in the same workbook changes color so that it stands out on the sheet.

    lev
    A H/L changes shades when you click on it anyway (until you close and re-open the file), but to make that change stay there - or to make the destination cell change color, I think will require VBA
    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

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,004

    Re: Hyperlinks and conditional formatting

    deleted my duplicate post

  5. #5
    Registered User
    Join Date
    12-04-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Hyperlinks and conditional formatting

    That's what I thought - my knowledge of VBA is sketchy to say the least but I will give it a go

    Thanks

  6. #6
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,186

    Re: Hyperlinks and conditional formatting

    Quote Originally Posted by Lev1948 View Post
    That's what I thought - my knowledge of VBA is sketchy to say the least but I will give it a go

    Thanks
    As I said before : if you describe what you want to do I can help.

  7. #7
    Registered User
    Join Date
    12-04-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Hyperlinks and conditional formatting

    My spreadsheet is a record of a swimming gala with all the results in age groups on 7 separate sheets. Each age group sheet has around 10 results for that age group with defined name headings for each event.

    The menu page is where I've collated all my hyperlinks that link to the respective result. For instance, click the 9 year girls 100m Butterfly and it sends you to the result heading (the defined name).

    What I want is for the heading to be highlighted in a colour so that it is easily spotted on the sheet.

    I hope I've explained in sufficiently for you.

    Regards
    Lev

  8. #8
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,186

    Re: Hyperlinks and conditional formatting

    That's useful. If you could attach a sample (please remove any real names or other identifiable information) use the Go Advanced option on the reply.

    I presume you created the hyperlinks by hand. How often would this be re-done (if at all)?

  9. #9
    Registered User
    Join Date
    12-04-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Hyperlinks and conditional formatting

    Hi

    I won't need to use any more hyperlinks (they were all done manually). I've removed columns B and K - they had the names of the swimmers.

    When you click a link on the Menu sheet it goes to the relevant page and set of results. These destination cells are the ones I would like to highlight when they are accessed by the hyperlinks.

    Spreadsheet attached.

    Regards
    Lev
    Attached Files Attached Files

+ 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. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  2. Outlook formatting for graphs and hyperlinks
    By BraveR in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 02-18-2014, 06:11 AM
  3. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  4. Formatting Cells for Hyperlinks
    By MamaWolf in forum Excel General
    Replies: 2
    Last Post: 03-18-2013, 01:20 PM
  5. Find Hyperlinks, Copy Hyperlinks to alternative sheet, print all hyperlinks
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2013, 05:13 PM
  6. Formatting HyperLinks
    By britt042 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-21-2011, 11:44 AM
  7. formatting cells as hyperlinks
    By barrygou in forum Excel General
    Replies: 3
    Last Post: 02-10-2010, 04:59 PM
  8. Conditional Hyperlinks?
    By Mhz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-24-2007, 02:48 AM

Tags for this Thread

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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.21081 seconds
  • Memory Usage 9,111KB
  • Queries Executed 16 (?)
More Information
Template Usage (35):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (2)bbcode_quote
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (9)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (1)postbit_attachment
  • (9)postbit_legacy
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (4)showthread_bookmarksite
  • (8)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (50):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • postbit_attachment
  • tag_fetchbit
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1