+ Reply to Thread
Results 1 to 7 of 7

How do I change a cell color when value in cell is changed?

  1. #1
    Registered User
    Join Date
    04-23-2015
    Location
    new york, ny
    MS-Off Ver
    2010
    Posts
    11

    How do I change a cell color when value in cell is changed?

    I have a project status worksheet where the PM has to select the status of their project. Depending on their selection, the color of the cell will change - e.g., G= green, Y = amber and R = red. Thoughts? Thank you.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: How do I change a cell color when value in cell is changed?

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    04-23-2015
    Location
    new york, ny
    MS-Off Ver
    2010
    Posts
    11

    Re: How do I change a cell color when value in cell is changed?

    Hello and thanks for the response...

    I do not see any attachment. Did I miss something?

    Thanks,
    -A
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-23-2015
    Location
    new york, ny
    MS-Off Ver
    2010
    Posts
    11

    Re: How do I change a cell color when value in cell is changed?

    My bad...I re-read your message and did attach a sample file. Hope this helps. Thank you!

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: How do I change a cell color when value in cell is changed?

    Maybe:

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    04-23-2015
    Location
    new york, ny
    MS-Off Ver
    2010
    Posts
    11

    Re: How do I change a cell color when value in cell is changed?

    Hi. Works like a charm!! Thanks!

  7. #7
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: How do I change a cell color when value in cell is changed?

    You're welcome. Glad to help out and 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] Change a cell in the same row but different column when a cell in a range is changed
    By ajam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2016, 12:25 PM
  2. Change a Range's cell background color to that of another cell's cond. format color
    By kamelkid2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2014, 12:57 PM
  3. Macro to change cell text color based on darkness of cell fill color
    By cincyshirm61 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-25-2014, 12:11 PM
  4. Change background color of cell when data has been changed
    By paperboy in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 09-13-2013, 05:00 AM
  5. [SOLVED] Cell color will be changed based on its value compare with previous cell value
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-02-2013, 02:09 PM
  6. Change cell fill when changed different color depending on the day
    By rev0jace in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-17-2012, 11:06 AM
  7. Cell value is changed, the cells change the color
    By lsuersoy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-06-2010, 07:17 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