+ Reply to Thread
Results 1 to 4 of 4

Change cell color if content changes

  1. #1
    Registered User
    Join Date
    09-27-2011
    Location
    Alabama
    MS-Off Ver
    Excel 2010
    Posts
    2

    Change cell color if content changes

    I need to change a cell's color to green if the current cell content changes in any way. Can this be done?

    Thanks in advance for any suggestions!

    DonaldJ

  2. #2
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Change cell color if content changes

    You can use Conditional formatting.
    Select the range and from the Home Ribbon select conditional formatting
    Select Highlight cell rules
    Choose Equal to
    And in the dialog type the word that you want to check for.
    Change the formatting to whatever you choose.
    Regards,
    Rudi

  3. #3
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Change cell color if content changes

    Actually rethinking your question...conditional formatting cannot check for if the cell changes (only if a value equals (or does not equal) something).
    You will need code to check for ANY type of value change...not just one that meets a set condition.

    I will set up an example for you...

  4. #4
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Change cell color if content changes

    Have a look at this sample workbook.
    It has some basic code that will capture value changes in cells A1:A10 only.

    To see/modify the code, right click on the sheet tab and choose View Code.
    Attached Files Attached Files

+ 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. Change Cell color based on other cell content
    By Mies07 in forum Excel General
    Replies: 4
    Last Post: 07-11-2012, 09:20 AM
  2. Tab color change based on cell content
    By sammi8796 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-02-2011, 02:15 AM
  3. Change cell color based on cell content
    By iscar_marius in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-07-2010, 12:55 AM
  4. Change cell color based on cell content
    By ADSK in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-13-2010, 02:29 AM
  5. Change the Back Ground Color on basis of content of cell in a range
    By ravinder_tigh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-01-2009, 11:36 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