+ Reply to Thread
Results 1 to 2 of 2

Font Colour for Linked cells

  1. #1
    Registered User
    Join Date
    01-29-2023
    Location
    Darwin, Australia
    MS-Off Ver
    2016
    Posts
    1

    Font Colour for Linked cells

    Hi, I have linked cells between 2 worksheets and would like the font colour that I enter on worksheet 1 to be used in the linked cell on worksheets 2-13. At the moment when change font colour in worksheet 1 to blue, it still comes up as black in worksheet 2-13. I don't want to have to manually change the font colour in the other worksheets. I'm using the font colour to highlight different events. Eg all events in blue are training, all events in green are meetings, all events in red means something is due.
    Is this possible?
    Thanks

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Font Colour for Linked cells

    Welcome to the Forum CL888 !

    If you color the cells on worksheet 1 manually, this requires VBA. To provide appropriate code you would have to give a lot detail about the logic used to link the cells. The best thing would be to provide a sample file. Are these two worksheets in the same file? See yellow banner at the top of the form.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Sum Cells by Font or Cell Colour without VBA
    By chaysp81 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-18-2021, 09:52 AM
  2. [SOLVED] Change font colour based on another cells value using vba
    By si_1970 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2016, 07:35 AM
  3. Sum cells by font colour
    By WSzaf in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-18-2015, 09:11 AM
  4. [SOLVED] Counting cells that are red in font colour
    By shiftyspina in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-06-2013, 10:32 AM
  5. Replies: 15
    Last Post: 05-31-2012, 10:34 AM
  6. Linking font colour between cells
    By melvin in forum Excel General
    Replies: 3
    Last Post: 02-23-2007, 12:20 PM
  7. Changing font colour in some cells
    By Di W in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-12-2006, 02:10 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