+ Reply to Thread
Results 1 to 7 of 7

Changing font color in a row when a value is entered into a specific cell

  1. #1
    Registered User
    Join Date
    11-25-2015
    Location
    Glendale, AZ
    MS-Off Ver
    2007 (at work) 2016 (at home)
    Posts
    4

    Question Changing font color in a row when a value is entered into a specific cell

    I have a spreadsheet with datra in this range: A2:AD343. This range is growing one row at a time. The number of columns is static.

    Example of what I need the worksheet to do automatically:

    I have already input values into cells A4:AB4. This text is black by default and needs to stay that color until a date is entered into cell AC4. Entering a date into AC4 should cause the text in cells A4:AD4 change to (RGB = 0,176,80) a green color.

    I am looking for VBA code for this to work.

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,600

    Re: Changing font color in a row when a value is entered into a specific cell

    Is that not easily done using conditional formatting?

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    or

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 11-25-2015 at 07:51 PM.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,992

    Re: Changing font color in a row when a value is entered into a specific cell

    Agree that you dont really need VBA for thism regulat Conditional Formatting will do what you want
    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

  4. #4
    Registered User
    Join Date
    11-25-2015
    Location
    Glendale, AZ
    MS-Off Ver
    2007 (at work) 2016 (at home)
    Posts
    4

    Re: Changing font color in a row when a value is entered into a specific cell

    Hi mehmetcik. Thank you for the reply.I do not want each cell to change when data s entered. I need all cells in the row to remain with black text until a value is entered into the AC cell for that row.

    EDIT:

    I just saw the 2 you placed in cell AC. Now that makes sense. My apologies for missing that.
    Last edited by A Noid; 11-25-2015 at 07:58 PM. Reason: Missed your entry

  5. #5
    Registered User
    Join Date
    11-25-2015
    Location
    Glendale, AZ
    MS-Off Ver
    2007 (at work) 2016 (at home)
    Posts
    4

    Re: Changing font color in a row when a value is entered into a specific cell

    But does this slow the calculations down as more rows of data are added? And will I also need to keep modifying the conditional format rule each time? The point is to just have the code to help automate this process.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,992

    Re: Changing font color in a row when a value is entered into a specific cell

    Quote Originally Posted by A Noid View Post
    But does this slow the calculations down as more rows of data are added?
    depends on how big your range is

    And will I also need to keep modifying the conditional format rule each time? The point is to just have the code to help automate this process.
    If you set up the CF range (Applies TO), to cover an few 100 rows nmore than you currecntly have, you should not need to fiddle with it for a while
    Last edited by FDibbins; 12-02-2015 at 06:01 PM.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,992

    Re: Changing font color in a row when a value is entered into a specific cell

    Happy to help, thanks for the feedback

+ 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. [SOLVED] Changing text font color in a cell...
    By Chubster in forum Excel General
    Replies: 3
    Last Post: 04-26-2012, 12:34 PM
  2. Changing font color in sum cell
    By Sindee123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-09-2012, 12:31 PM
  3. Replies: 7
    Last Post: 05-26-2011, 03:44 PM
  4. difficulty writing code for changing font color if cell contains specific text
    By curbster in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-13-2009, 03:23 AM
  5. Changing font color of active cell
    By ridesisapis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2009, 08:10 PM
  6. Changing cell color once text is entered
    By KRayKeeling in forum Excel General
    Replies: 1
    Last Post: 08-05-2007, 11:36 AM
  7. changing font color of cell content
    By Donald Stockton in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-09-2006, 01:55 PM
  8. Changing Cell Font and Color Issue,
    By RitaG in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-31-2005, 08:06 PM

Tags for this Thread

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