+ Reply to Thread
Results 1 to 7 of 7

Highlight cell that was changed (from NOT empty value)

  1. #1
    Registered User
    Join Date
    04-06-2012
    Location
    San Bruno, USA
    MS-Off Ver
    Excel 2003
    Posts
    32

    Highlight cell that was changed (from NOT empty value)

    Hi, all

    Is it possible to program excell sheet that if I changed some value in cell from initial value to another it will be highlited. I work on food order sheet for one non profit, so we trying to make it work.
    It should only work after initial value has been entered, not when initial value entered into Empty cell.
    There also some vb macro already in this workbook, hope it will work well with them.

    Generally I trying to emprove existing order sheet with all details for food delivery for one non profit. The only thing they have is MS donated Office 2007, so I'm trying to do my best of it. In this sheet we trying to track any order change so our drivers will see it clearly.


    THanks to all for help.
    Last edited by dainova; 04-13-2012 at 12:34 PM.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Highlight cell that was changed (from NOT empty value)

    You can put some macros into the sheet module to help with this. Right-click the sheet tab and VIEW CODE, then add in this code:
    Please Login or Register  to view this content.

    There can only be one ws_selectionchange and one ws_change macro in a sheet module, so if you have macros in there like that already, you'll have to merge them.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    04-06-2012
    Location
    San Bruno, USA
    MS-Off Ver
    Excel 2003
    Posts
    32

    Re: Highlight cell that was changed (from NOT empty value)

    Thanks so much, JBeaucaire !!
    IT work perfectionne.
    is it also possible to set specific cell for given row to some value "CHANGE",
    Please Login or Register  to view this content.
    Can anybody help to finish this,

    Thanks
    Dai

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Highlight cell that was changed (from NOT empty value)

    Try this:

    Please Login or Register  to view this content.

    If that takes care of your need, please click Thread Tools above your first post and mark this thread as SOLVED.

  5. #5
    Registered User
    Join Date
    04-06-2012
    Location
    San Bruno, USA
    MS-Off Ver
    Excel 2003
    Posts
    32

    Re: Highlight cell that was changed (from NOT empty value)

    Thanks, JBeaucaire

    It doesn't work for me, let me take a break to digest all information.

    Thanks all
    Dai

  6. #6
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Highlight cell that was changed (from NOT empty value)

    DId you include the ws_selectionchange in that module, too, from the prior post? It would all look like this, I've tested and it works:

    Please Login or Register  to view this content.

  7. #7
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Highlight cell that was changed (from NOT empty value)

    @ JBeaucaire

    I follow your posts regularly, and I must say this one is short, sweet and good!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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