+ Reply to Thread
Results 1 to 4 of 4

VBA code to change font colour of cell referenced letter strings within a range of cells

  1. #1
    Registered User
    Join Date
    06-13-2014
    Posts
    10

    VBA code to change font colour of cell referenced letter strings within a range of cells

    I am working on a spreadsheet for work, and have managed to do everything I need to so far but I need to colour specific letter strings, certain colours within a range of cells (each letter string will only appear once on each sheet)

    The strings I will be looking for vary depending on data entered so I will need to cell reference them

    The strings that need colouring are in cells with other strings that must stay black (They cannot be separated from other strings due to the nature of the grid)

    I need some strings red, some green, and some blue.

    These changes should also apply to the whole workbook not just one sheet.

    Is there a way to do this with the VBA code.

    I hope that makes sense. Unfortunately I am not allowed to post the workbook I am working on online just to my workplaces Intellectual property policy.

    Thank you very much
    Last edited by Klofange; 06-14-2014 at 01:20 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,536

    Re: VBA code to change font colour of cell referenced letter strings within a range of cel

    color some words
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    06-13-2014
    Posts
    10

    Re: VBA code to change font colour of cell referenced letter strings within a range of cel

    Hi there, thank you for your response, I am having a problem getting it to work (and I can't open your file, it seems to be a shortcut)

    So if the word that need searching for are in cells BH2:BH32 (green), BI2:BI32 (blue), BJ2:BJ2 (red)

    and the range of cells I want the colours to change in is C6:AK22

    how would I vary the VBA you gave me?

    Cheers again

    Harrison

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,536

    Re: VBA code to change font colour of cell referenced letter strings within a range of cel

    Please Login or Register  to view this content.

+ 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. 1. Sheet Range Tab colour changed based on Cell value referenced against 3 lists
    By james 35 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2013, 07:20 AM
  2. using a command button to change certain cells font colour.
    By ncaravela in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-17-2013, 10:08 AM
  3. VBA code to change font color in range of cells when certain text is entered?
    By BrianG in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-21-2012, 06:30 PM
  4. Change the font colour according to the data range
    By nilusara in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-23-2008, 06:03 AM
  5. [SOLVED] change a cell colour when entering a letter
    By paul42770 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-27-2005, 04:05 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