+ Reply to Thread
Results 1 to 6 of 6

How to make fill color a hyperlinked cell

  1. #1
    Forum Contributor
    Join Date
    11-10-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2013
    Posts
    297

    How to make fill color a hyperlinked cell

    I wan to change the fill color of each any hyperlinked cell.
    Non hyperlinked cells are normal, not to be colored.

    In attached file , defined detail and what is wanted.

    Thanks in advance for any reply and help.

    Regards,
    turist
    Attached Files Attached Files

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: How to make fill color a hyperlinked cell

    One possible way :-
    Please Login or Register  to view this content.
    Regards Mick

  3. #3
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: How to make fill color a hyperlinked cell

    Without adding anything MickG has not done, I personally prefer to use the RGB color directly as the colorindex can be changed:

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    11-10-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2013
    Posts
    297

    Re: How to make fill color a hyperlinked cell

    Quote Originally Posted by MickG View Post
    One possible way :-
    Please Login or Register  to view this content.
    Regards Mick
    Dear Mick,
    Works, great.
    Thanks a lot for your kind help.
    Regards,
    turist

  5. #5
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: How to make fill color a hyperlinked cell

    You're welcome
    Regrds Mick

  6. #6
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: How to make fill color a hyperlinked cell

    turist, thanks for the rep

+ 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. How to color-fill blank cells, then once data is entered cell is no-fill
    By hatemail13 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-28-2013, 07:57 PM
  2. Replies: 0
    Last Post: 09-26-2012, 01:08 PM
  3. Replies: 0
    Last Post: 04-06-2009, 04:07 PM
  4. Can I make if functions based on fill color?
    By nickclingan in forum Excel General
    Replies: 2
    Last Post: 11-07-2005, 06:50 PM
  5. [SOLVED] How do I make the fill color of a cell on one sheet follow the co.
    By SteelerfanDan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-08-2005, 06:06 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