+ Reply to Thread
Results 1 to 1 of 1

VBA to mark/change font color of all source cells linked (i.e. alternative for CTRL + [ )

  1. #1
    Registered User
    Join Date
    04-15-2008
    Location
    Tamil Nadu, India.
    MS-Off Ver
    Microsoft Office 2016
    Posts
    584

    VBA to mark/change font color of all source cells linked (i.e. alternative for CTRL + [ )

    Dear Friends,

    I have a sheet in which cells are linked from other sheets. I just want to ensure that all links are correct or not.

    I know that the CTRL + [ will take me to Source cell.

    But, I just want to "Change the color of Font" of all SOURCE cells that are linked in compilation sheet.

    Request your kind help with a VBA to change font color of all source cells that are linked in a sheet. i.e. bulk execution for CTRL + [

    One more addition:

    The linked cell is in a formula like -
    Please Login or Register  to view this content.
    So, the VBA to identify all sources referred in the formula and mark the values of source cells in "Red".

    Please help me.
    Last edited by acsishere; 09-17-2019 at 09:56 AM.
    Good friends are hard to find, harder to leave, and impossible to forget.

    acsishere.

+ 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. VBA to Change the Font Color if the Cells Value has Changed
    By PandoraGirl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-24-2019, 05:50 AM
  2. change cell color only if that cells font color is black and it's value is < 2000
    By randall78 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-05-2019, 05:23 PM
  3. Change Source alternative
    By carlos.pinto in forum Excel General
    Replies: 0
    Last Post: 06-10-2014, 04:00 PM
  4. Replies: 2
    Last Post: 02-04-2013, 02:00 PM
  5. Change font color based on font color of another cell
    By Ibyers in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2012, 09:36 AM
  6. Change Font Color in a Range based on One Cells information
    By mrgillus in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-28-2009, 11:58 AM
  7. Replies: 1
    Last Post: 01-04-2005, 12:06 AM

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