+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting - if there is hyperlink

  1. #1
    Registered User
    Join Date
    08-31-2006
    Posts
    11

    Conditional Formatting - if there is hyperlink

    A simple question for experts here:

    I want to have a CONDITIONAL FORMATTING based on if the cell has a Hyperlink.

    so this:

    If I were to add a hyperlink on the cell, then it would be GREEN, otherwise it remains YELLOW.

    Could I do this with VBA?


    thanks

  2. #2
    Registered User
    Join Date
    07-24-2017
    Location
    Perth, Australia
    MS-Off Ver
    2016, 365
    Posts
    6

    Re: Conditional Formatting - if there is hyperlink

    I'm looking for an answer too, has anyone got one?

  3. #3
    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,945

    Re: Conditional Formatting - if there is hyperlink

    Quote Originally Posted by WadMabbit View Post
    I'm looking for an answer too, has anyone got one?
    I know that question was not answered, but...
    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    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)

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