+ Reply to Thread
Results 1 to 2 of 2

Compare Two Fields and Highlight Cell if Different.

  1. #1
    Registered User
    Join Date
    10-08-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    2

    Compare Two Fields and Highlight Cell if Different.

    I need a way to detect a cell change and then have the cell background color change. Here is a layout/description of the issue:

    WB1 - this will be my main data file that updates WB2. Parts of the data within WB1 can change on daily basis. Therefore, I plan to simply "overwrite" the existing WB1 file with a new one each day when I get them. (example: Data.xls)
    Sheet1 - this has all of my rows of data including a unique identifier (Account #) that will allow me to tie my WB2 to WB1.
    Cell A1 - Account Number
    Cell B2 - Notes

    WB2 - this will be my Master file that I will work from on a daily basis. My intention here is to have the WB1 (Data.xls) document to update cell A2 on WB2 with a simple formula of (WB2!B1 = [Data.xlsx]Sheet1!B1). This works great to make sure that all of my notes from the updated WB! (data.xls) get updated into my WB2 file using a VLOOKUP on A1 back to the data.xls file. However, my goal is to have the cell color change for only the notes that actually changed.

    Example: WB2/B2 originally said, "This is my note." But when I replace the data.xls file, the note (B2 in data.xls) now reads, "This is my updated note". Therefore, WB2 would be updated with this updated note and my goal would be that the system would detect that the "contents" of the note are different than what it was before it updated the field and would update the data and change the cell color.

    I have tried to use "EXACT" as part of my formula, but the data updates have already occured and therefore, the comparison is always TRUE.

    Can anyone tell me and provide me a sample code of how I can achieve this?

    I appreciate your assistance with this question and I hope that I can return the favor one day as well.

    Sincerely,
    Doug

  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: Compare Two Fields and Highlight Cell if Different.

    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 use the paperclip icon to open the upload window.

    View Pic
    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

+ 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. Replies: 3
    Last Post: 09-08-2014, 10:36 AM
  2. [SOLVED] Compare two colums from different sheets and to highlight the different cell in sheet 2
    By Thinker8 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-26-2013, 04:46 AM
  3. Replies: 2
    Last Post: 07-09-2013, 01:00 PM
  4. Compare values in a different cell and highlight if wrong
    By traciey in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-26-2012, 06:12 PM
  5. [SOLVED] compare info in 4 worksheets and highlight fields that are the sam
    By Ellen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-25-2005, 06: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